Hi Bojidar,

why do you claim this would be better:

SELECT *

FROM t1 a

LEFT JOIN t2 b ON a.f1=b.f1

WHERE b.f1 IS NULL

You didn't give any proof. Did you examine what the optimizer does with it?

My opinion: No good SQL. You should better reconsider this

cheers

jens