Related Topics
Website Development
The website technology supporting Philadelphia Reflections is PHP, MySQL and DHTML. The web hosting service is Internet Planners.
George IV and Computers(1)
I got him into computers around 1960. He soon far surpassed me.
Programming;GRF4
Program notes by GRF4
New topic 2020-08-31 17:59:48 TITLE 681: Blog 1021 :
DESCRIPTION: this is where you put a small summary blurb which appears in the section surrounded by a black box.
SQL To Exclude A List Of Items
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
Please Let Us Know What You Think