Multi-part specification SQL error

Question

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?

Answer 1

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]