you can start from a select
select * FROM T1 INNER JOIN T2 ON T1.key = T2.key WHERE condition;
when good, switch to delete mode
DELETE T1, T2 FROM T1 INNER JOIN T2 ON T1.key = T2.key WHERE condition;