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 have a query, call qry_AssociatedFeatures, that finds all features associated with a
given plan
SELECT functionalsubgroup.Functional, functionalsubgroup.SubGroup, main_db.Feature,
main_db.FeatureKey, functionalsubgroup.FSKey, featureenable.PlanName
FROM featureenable INNER JOIN (main_db INNER
-
From: Bartis, Robert M (Bob) [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 09, 2004 8:48 AM
To: [EMAIL PROTECTED]
Subject: Finding records not in a set
I have a query, call qry_AssociatedFeatures, that finds all features associated with a
given plan
SELECT functionalsubgroup.Functional