[AccessD] SQL - Alternative to using NOT IN Clause

Heenan, Lambert Lambert.Heenan at AIG.com
Thu Jul 24 08:13:26 CDT 2008


That would be a straightforward Unmatched query for which there is a wizard
when you hit the New button in the query window.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Thursday, July 24, 2008 4:57 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] SQL - Alternative to using NOT IN Clause

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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list