What you wanted to show is a so-called exception join. But this is not a good way:

select * from t1

where t1.f1 not in (select t2.f1 from t2)

Exception joins should better be implemented like this:

select * from t1

where not exists (select 1 from t2 where t1.f1 = t2.f1)

cheers

jens