comparing 3 tables and listing the unmatched

[sdollen]

Sounds very strange, huh?? I think it is.

I have a table with city names (tblMunicipality). I have a contact table where we list cities that we visit for work purposes(tblContacts). (The city is our client so to speak). I have a third table where we list the city and the conference they attend and that we see them at(tblAttendees).

All of these are related by the City name.

How can I create a query that lists all cities on tblMunicipality where "MunicipalityName" does not match "MunicipalityName" on tblContacts AND tblAttendees?

This should give me the results of every city that has not had a contact AND not attended a conference.

Does that make sense? I'm confusing myself

THanks for any help!

-Stefan

 

[gol4]

You should be able to accomplish this using left joins and looking for null.
see find unmatched queries in Access