I can write some SQL, but I'm not good at knowing how to make things perform better. My query below works with one JobID, but I need to pull openers from 5 jobs. When I do this it times out. I'm thinking there is a better way to write this, but I'm still new to SQL and don't know much about what performs better than what. Any suggestions?
select distinct s.SubscriberKey from _sent s WHERE s.JobID IN ('2787871','2787957','2787958','2787970','2787971') AND s.SubscriberKey NOT IN ( SELECT o.SubscriberKey FROM _Open o WHERE s.JobID IN ('2787871','2787957','2787958','2787970','2787971') )