table1 - table2 = query_result?

[w3bm0nki]

I am working in Access XP and need to do the following.

table1 - table2 = query_result

Table1 and Table2 each have 4 fields that match. I want to show everything from table1 that does NOT exist in table2? Is this possible in access?

 

[Golom]

Select A.*
From Table1 As A LEFT JOIN Table2 As B
ON A.f1 = B.f1
AND A.f2 = B.f2
AND A.f3 = B.f3
AND A.f4 = B.f4
WHERE B.f1 IS NULL

 

[w3bm0nki]

Thanks, that's exactly what I needed!