If you want to delete from a table and select from the same table in a subquery (MySQL makes it hard):


DELETE FROM Table1
WHERE id
IN ( SELECT id FROM
(SELECT A.id FROM Table1 A
LEFT OUTER JOIN Table2 B ON B.id = A.other_column WHERE B.id is null)
AS BOGUSTABLENAME)