NOT IN Query

[JohnWales]

I have to compare two tables with the result of a query to show all records in tbl1 and tbl2 tha are NOT IN Qry1
How would I format a new query to do this?

 

[FoFa]

SELECT Col1, Col2, etc.
FROM TBL1
where TBL1.PK NOT IN (SELECT QRY1.PK from QRY1)
UNION ALL
SELECT Col1, Col2, etc.
FROM TBL2
where TBL2
where TBL2.PK NOT IN (SELECT QRY1.PK from QRY1)

As one possible way