• Better way is:

    SELECT *

    FROM t1 a

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

    WHERE b.f1 IS NULL