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