thanks for the reply...

but what is the sql statement if it is NOT IN instead of IN

select * from table1 where (f1, f2) not in (select f1, f2 from table2 )