I have 2 Tables both are have the same structured.
let say
Table 1 Table 2
FName FNAMe
MNAme MNAme
LNAMe LNAMe

I want to see all Match records from Table2 to Table1

Ok I used Inner Join on FNAME = FNAMe... etc..
I got the correct Results.

Now the problem is I want to get all records that are not matched from both tables.
What queries should I Use?

Appreciate all your help

Thanks,
ELmer

Try this:

SELECT Table2.FName
FROM Table2
WHERE (((Table2.FName) Not In (SELECT Table1.FName FROM Table1 INNER JOIN Table2 ON Table1.FName = Table2.FName)))
Union
SELECT Table1.FName
FROM Table1
WHERE (((Table1.FName) Not In (SELECT Table1.FName FROM Table1 INNER JOIN Table2 ON Table1.FName = Table2.FName)));

There may be an easyer way

You may want to try using the Find Unmatched query wizard. Just select the table that has records that do not match those in the other table

Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself

"A Person Who Claims To Be A Flash Junkie Isn't Really A Flash Junkie Unless He Can Prove It"

Instead of this you can use this method:


SELECT * FROM table1 LEFT JOIN table2 ON table2.number = table1.number WHERE table2.number is NULL OR table1.number is NULL


It works ...