[AccessD] SQL - Alternative to using NOT IN Clause

Gustav Brock Gustav at cactus.dk
Thu Jul 24 06:05:57 CDT 2008


Hi Max

Could it have been your own thread "Optimizing subqueries" in June?

Anyway, you can make a helper query which the item to deselect, and in your main query create an outer join to this and use a where clause with Is Null for the key of the helper query.

/gustav

>>> max.wanadoo at gmail.com 24-07-2008 10:56 >>>
Hi Guys,
Somebody posted an alternative to NOT IN (something to do with testing for
nulls) but for the life of me, I cannot find it now that I need it.
Could anybody help me out here please.
Thanks
Max





More information about the AccessD mailing list