select * from table1 where myPK not in (select myFK from table2) or select * from table1 where myField not in (select myField from table2) or, if you determine that myField1 to myFieldN are the ones that guarantee uniqueness: select * from table1 T1 where myPK not in (select myPK from table2 T2 where T1.F1 == T2.F2 and... T1.Fn == T2.Fn)