querying 2 tables to exclude non-matching records

[Guest]

I have 2 tables. One listing residents of a community, the other listing
members of a club. How can I arrive at a list of community members who are
not members of the club?
Thanks.

 

[Steve Huff]

Ok you'd create a query with both tables and then join them by the Primary
Key like member ID then you'd double click on the join line and select the
statment that said something like:

"Include ALL records from tblClub and only those records from tblCommunity
where the joined fields are equal."

Then you'd bring down all the fields that are relevent to tblCommunity to
the field listing and you'd bring down the MemberID from tblClub and add the
Criteria "Is Null"

Here is an example of what the resulting SQL would be:

SELECT tblClub.FName, tblClub.LName
FROM tblClub LEFT JOIN tblCommunity ON tblClub.MemberID =
tblCommunity.MemberID
WHERE tblCommunity.MemberID Is Null;

Hope that helps...

 

[John Vinson]

I have 2 tables. One listing residents of a community, the other listing
members of a club. How can I arrive at a list of community members who are
not members of the club?
Thanks.

There is an "Unmatched Query Wizard" which will do just this; create a
new query and select that wizard.

John W. Vinson[MVP]