query about people who appear in X table and do not appear in Y table

[Locomotive]

how can i make a query about people who appear in one table and do not appear in the other table?

for example:

table - sex workers:

1. Monica
2. Linda
3. Daniel
4. Mahmouda

table - blonde prostitutes

1. Linda
2. Daniel

Querry that I need:

NON BLONDE PROSTITUTES.

Needs to show:

1. Monica
2. Mahmouda

How do I do this?

 

[bjackson]

it may be better if you had 1 table of prostitutes and
as field names have
ProstituteId
Firstname
Lastname
HairColour
Nationality
Likes
DisLikes
AreaofExpertise
etc
etc
that way would make it easy to run a query based
on hair colour,nationality or what ever

 

[Locomotive]

but let's say i'm an illegal female trader who is trading 10.000 woman and can't change anything now... possible to do anything?

 

[HockeyNut]

Wouldn't a 'select' query using a "not equal" condition, to compare the 2 tables, do the trick?

David

 

[Locomotive]

I have no idea, I'm new to access.
Thank you very much for your advice.
Could you describe this process?

 

[Locomotive]

By the way, a better example to what I mean:

I have two tables:

Windows Users
Access Users

Let's say I work in Microsoft and I want to encourage Windows Users to use Access. For this I need to create a query with Windows users that do not use Access.

 

[HockeyNut]

Using you Windows & Access users analogy.

SELECT WINDOWS.EmployeeID, ACCESS.EmployeeID (and whatever other fields you want displayed)
FROM WINDOWS, ACCESS
WHERE WINDOWS.EmployeeID <> ACCESS.EmployeeID;

From what I gather this type of condition should serve the purpose.

Good luck,
David

 

[AncientOne]

There is a query wizard which does what you want: it's the "Find Unmatched" Wizard.

 

[Locomotive]

What would I do without guys I don't know. T-H-A-N-X!!!!