Evelyn,
You need some PK to test for, or at least some field:
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)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
