Show result of TblA not in TblB

I

Ian

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.
 
D

Duane Hookom

I believe there is a query wizard that walks you through this. Come back if
you can't find it on your own.
 
I

Ian

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.
 
J

John W. Vinson

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]
 
I

Ian

still couldn't do it in SQL if I wanted to but it worked like a charm.
Thanks guys.
 
Top