SFMC: Query to select all subscribers who have recieved and EmailID

Question

I'm trying to create a Data Extension with Subscribers who have received a specific email. All I can find online relates to the JobID, but this email is sent daily and I need it to pull by EmailID.

When I check syntax I keep getting errors. Please help. This is the query.

SELECT su.EmailAddress as Emailaddress,su.SubscriberKey 
FROM _Subscribers su WITH (NOLOCK)
JOIN _Sent se WITH (NOLOCK) 
ON su.SubscriberID = se.SubscriberID
where s.EmailID = 2521896

I've also tried this:

SELECT su.EmailAddress as Emailaddress,su.SubscriberKey 
FROM _Sent se WITH (NOLOCK)
LEFT JOIN _Bounce b WITH (NOLOCK)
ON se.EmailID = b.EmailID
AND se.ListID = b.ListID
AND se.BatchID = b.BatchID
AND se.SubscriberID = b.SubscriberID
JOIN _Subscribers se WITH (NOLOCK) 
ON su.SubscriberID = se.SubscriberID
WHERE s.EmailID = 2521896
AND b.EmailID IS NULL

Answer 1

Two things have popped up for me when testing this out:

1. You are referencing the EmailID as 's.EmailID' when your alias for the _Sent Data View is 'se'

2. The attribute 'EmailID' is only stored at the 'Job' level. You will need to make another join onto the Job Data View through the JobID field to gain access to that level of information.

---

SELECT DISTINCT su.EmailAddress, su.SubscriberKey
FROM _Job as j WITH (NOLOCK)
INNER JOIN _Sent as se WITH (NOLOCK) on j.JobID = se.JobID
INNER JOIN _Subscribers as su WITH (NOLOCK) on se.SubscriberID = su.SubscriberID
WHERE j.EmailID = 2521896

Answer 2

Finally Support was able to provide me with working code. Seems it was missing ENT

    SELECT DISTINCT su.EmailAddress, su.SubscriberKey 
FROM _Job as j WITH (NOLOCK) 
INNER JOIN _Sent as se WITH (NOLOCK) on j.JobID = se.JobID 
INNER JOIN ENT._Subscribers as su WITH (NOLOCK) on se.SubscriberID = su.SubscriberID 
WHERE j.EmailID = 2521896 

Thanks Annon and Jim for helping me get started!