Show result of TblA not in TblB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main tblA with all clients. If they have any current contracts they
are in tableB. How do I show the clients of A that are not in B?

Thanks Ian.
 
I believe there is a query wizard that walks you through this. Come back if
you can't find it on your own.
 
don't think the wizard will help with this because in the select on client in
TblB I have some other JOINS going on to select out the appropriate list. I
usually use the design view but can do it in SQL if I have too for UNION
joins and stuff.

I know it's a silly question but for the life of me I can't think of the
logic I need to use to exclude the show only the clientID's in TableA that
are NOT included in TableB. All the joins I usually use only let me show
ID's that are included in both tables one way or another.
 
I have a main tblA with all clients. If they have any current contracts they
are in tableB. How do I show the clients of A that are not in B?
Click to expand...

Use the "Unmatched Query Wizard" in the Query window (new query, use
the wizards).

John W. Vinson [MVP]
 
Back
Top