Please help me with a query

[newboy18]

I have a Table of Names and a Table of Addresses.
I want to join the 2 together in another Table using a
Form with 2 CombBoxes but I only want to see the Names
that have not been use yet in my Name Combobox, I dont
want to see all the Names.
How can I create a query of all Names in Table 1 that are
NOT in Table 2?

 

[mpastore]

try...

select myname from table1 where table1.name not in(select myname from table2)

Mike Pastore

Hats off to (Roy) Harper

 

[newboy18]

Thanks Mike but I found there is an Unmatched Query Wizard that does the job