Dude,

this join ´ll work work fine for most instances, but put a row in T2 where F1 is null and u ll got a real problem.

select * from t1where t1.f1 not in (select t2.f1 from t2)

I suggest it

select * from t1where t1.f1 not in (select t2.f1 from t2 AND T2.F1 IS NOT NULL)

Bojidar,

I try to avoid outer joins because at least one table is full scanned. Not good for joining two big tables with workable indexes. For performance i guess the NOT EXISTS solutions above wins, but i can be wrong. Try two or more ways to do thing with a eye in the execution plan can be instructive. =)