Matching & NOT MATCHING

[Jinny]

Ok so here's my problem:
i have 2 tables: Jeff, SD
there are 5 fields in each: ID (primary key) and 4 others
First I have to make a query that finds matching records in the 2 tables
This should be easy but it's not:
just simple join in design view, but when I run it says I need
something in the "Field:" box below~ so i put 4 fields from Table Jeff that I
want to show in the boxes and run and nothing comes up

Next I want to show the records that don't match between the 2 tables:
So you should make another query right join the 2 tables (show all of
jeff and matches of SD) then make the primary key for jeff (is null)
what else do i put in the "field, table, criteria" section?
b/c this is not working

Please help!!!

 

[JoAnn]

When you look in the tables directly, do you see records that should match?
IE, You have SD.ID = 1 AND Jeff.ID = 1, so a join should return the data from
those records if you join the ID fields.

For NOT matching, you want to put the other 4 fields from the SD table into
the Fields since the Jeff table fields will be NULL.

Note, there is a wizard when you make a new query that will do the not
matching for you. Look at all your options when you say you want to make a
new query.

JoAnn
Heritage Computer Consulting & Services, Inc