Show result of TblA not in TblB

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

 

[Guest]

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

 

[Guest]

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.

 

[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?

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

John W. Vinson [MVP]

 

[Guest]

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