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