[AccessD] SQL - Alternative to using NOT IN Clause

Thanks Lambert.

Max



On Thu, Jul 24, 2008 at 2:13 PM, Heenan, Lambert <Lambert.Heenan at aig.com>
wrote:

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