PROTECTED]
Sent: Saturday, October 09, 2004 9:30 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Finding records not in a set
Keep in mind EXISTS/NOT EXISTS are for SQL (Parent) Heavy queries
Otherwise you should use IN/NOT IN
Martin Gainty
617-852-7822
Man1: In my next life I want to get
I did find a reference to EXIST/NOT EXISTS clause in the SQL manual, but I get an ODBC
Failed call when I run the following simplified query
SELECT *
FROM main_db
WHERE NOT EXISTS (SELECT * FROM featureenable WHERE featureenable.FeatureKey =
main_db.FeatureKey);
Bob
-Original Message-