Query to Determine which record is not part of a Master Record Table

[carrionk]

Hi,
I need to compare if certain records are contained whithin a Master
Table.

The following tables illustrates the comparing tables and the required
Result

Master Table
============
Field1 Field2
1000 001
1000 002
1000 003
2000 001
3000 001

Comparing Table
===============
Field1 Field2
1000 001
1000 004
2000 002
3000 001

Resulting Table-which shows which record are not part of Master Tbl
===============
Field1 Field2
1000 004
2000 001

How do I perform this query?

Regards LC

[carrionk]

There's an error in the previous post the result should be:

Resulting Table-which shows which record are not part of Master Tbl
===============
Field1 Field2
1000 004
2000 002

I've trying to use "EXISTS" with no result:

Being: Master Table Name="tblMaster"
Comparison Table Name="tblComparison"

SELECT Field1, Field2 from [tblComparison]
WHERE NOT EXISTS
(Select Field1, Field2 from [tblMaster])

Select

[pietlinden]

did you try the find unmatched query wizard?

Basically it uses an outer join.

SELECT tblA...
FROM tblA LEFT JOIN tblB ON tblA.Field1=tblB.Field2
WHERE tblB.Field2 IS NULL;