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