IT:AD:SQL Server:HowTo:SQL:DML:Select:Minus Another
Related:
need a query that will return all of the records in the emailcampaign MINUS any in the unsubscribe table so that we will not mail any emails to people who have unsubscribed.
Select * From Emailcampaign Where email Not In (Select email From Unsubscribe)
Or
Select * From Emailcampaign e Left Join Unsubscribe u On e.email = u.email Where u.email Is Null