Can someone help me with this?

[netbytes]

Hi,

This is my problem:

Create a query that creates a list of records that did'nt match both in the first table and in the second table.
Meaning just display the unmatched records.

For Example:

FirstTable.table

RecNum Name Country
01 Mia PH
02 Ren MY
03 Hary US


SecondTable.table

RecNum Name Country
01 Mia PH
02 Ren MY
04 Joshua UK
10 Luna VN


QUERY TABLE

Displayed Records - Unmatched

RecNum Name Country
04 Joshua UK
10 Luna VN


See that the records 01 and 02 from the first table matches with the second table. So they would not be displayed.

This will use INNER JOIN? or what?


Thank you,

Hope someone can answer my questions.

God Bless

 

[dkinley]

You can use the Query Wizard. There is a choice to do an 'unmatched' query.

The wizard will walk you through the process. You will 'link' a field from table A to table B and it will return all unmatched records in A.

Subsequently, you will also need to do one from table B to table A with the same field link to get the records from B that don't match A for a complete list.

-dK

 

[Big Pat]

In the Queries view, click New and then select Find Unmatched Query Wizard. Answer the various questions and you should find it easy enough to do this.

Afterwards, go into design view of the query you make and study it. I learned a lot about how queries work doing things this way. You can see the basic idea and then start experimenting with it.

 

[netbytes]

Thank you guys,

Ok done!

 

[dkinley]

You betcha.

-dK