querying 2 tables to exclude non-matching records

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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...
 
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.
Click to expand...

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

John W. Vinson[MVP]
 
Back
Top