Related Topics
No topics are associated with this blog
Let's say you have a table "Primary" that contains an "Email" field.
You would like to select all the email addresses in Primary except for the list of email addresses in the Email field in a table "Exclude".
This SQL will exclude the emails in "Primary" based on those contained in "Exclude".
SELECT * FROM Primary WHERE ((Primary.Email) Not In (SELECT Email FROM Exclude))
Originally published: Monday, March 17, 2008; most-recently modified: Monday, June 04, 2012