How do you query for users that did not open an email by JobID in marketing cloud?

Question

I'm trying to figure out how to extract users that did not open an email with specific jobID's. This is what I have so far that doesn't seem to be working correctly. Any help would be appreciated.

SELECT
s.SubscriberKey
, s.JobID
FROM _Sent s 
WHERE s.SubscriberKey NOT IN (
  SELECT 
  o.SubscriberKey 
  FROM _Open o  
  WHERE s.JobID = 22008 OR s.JobID = 22007
)

Answer 1

Your query is selecting subscribers from ALL sends and then excluding anyone who opened Job 22008 OR 22007. Is this what you are looking for?

What I think you are wanting is a list of only subscribers that were sent job 22008 or 22007 and exclude anyone who opened one of these two emails. Is this a correct way to re-state your requirements?

To accomplish this, I would first select distinct subscribers from these two jobs:

select distinct s.subscriberKey
from _sent s
where s.JobID = 22008 OR s.JobID = 22007

Then I would update the query to exclude subscribers who had opened an email that corresponds to one of these two job:

select distinct s.subscriberKey
from _sent s
where s.JobID = 22008 OR s.JobID = 22007
and s.SubscriberKey NOT IN (
  SELECT o.SubscriberKey 
  FROM _Open o  
  WHERE o.JobID = s.JobID
  AND o.SubscriberKey = s.SubscriberKey
)