0

I am trying to pull bounce information for subscribers of a particular data extension using the following SQL:

Select 
o.JobID,
o.SubscriberKey,
o.EventDate,
o.BounceCategory,
o.SMTPCode,
o.SMTPBounceReason,
o.ListID,
s.ListName
s.Email address
from [_bounce] o
INNER JOIN 'ent.EDU SPIRIT DATA COMBINED' s
    ON o.SubscriberKey=s.Email address

I am receiving a multi-part specification error saying it's not allowed.

Can anyone shed any light on why please?

1 Answer 1

3

Replace your single quotes surrounding the Data Extension name with square brackets. Any field or data extension name that contains a space should be surrounded with brackets.

Select 
o.JobID,
o.SubscriberKey,
o.EventDate,
o.BounceCategory,
o.SMTPCode,
o.SMTPBounceReason,
o.ListID,
s.ListName,
s.[Email address]
from [_bounce] o
INNER JOIN ent.[EDU SPIRIT DATA COMBINED] s
  ON o.SubscriberKey = s.[Email address]
2
  • I believe double quotes can also be used " in this way. e.g. s."Email address" Mar 12, 2020 at 18:09
  • Thank you @Gortonington, I have deduced that it is because the data extension name contains spaces and for some reason it doesn't work when you join with a data view. Mar 13, 2020 at 9:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.