suppongo
delete from table where id in (select ... left join ...)