delete t1 from Table1 t1 where not exists ( select * from Table2 where value1 = t1.field1 and value2 = t1.field2 )