[AccessD] NOT Query.

Darryl,

SELECT * FROM QueryB LEFT JOIN QueryA ON QueryB.Clients = QueryA.Clients
WHERE QueryA.Clients Is Null

Regards
Steve


--------------------------------------------------
From: "Darryl Collins" <Darryl.Collins at coles.com.au>
Sent: Monday, March 30, 2009 4:12 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: [AccessD] NOT Query.

> Hi There,
>
> Having a complete brain fade.  (heh, must be suffering from 'Ribbon 
> fatigue' or trying to imagine NULL).
>
> I have two queries.  Query A and Query B both contain a field called 
> Clients (Based on the same underlying data).  A and B correctly return a 
> different number of records in the client field.  I want to be able to 
> list which clients are in query B that are missing in Query A.  Basically 
> I want the opposite of joining the two queries based on the clientfield.
>
> This should be easy, but I am stuck! :-(
>
> any pointers?
>