delete from t1 where exists ( select * from t1, t2 where t1.f1 = t2.f1 and t1.f2 = t2.f2 )
select * from t1, t2 where t1.f1 = t2.f1 and t1.f2 = t2.f2