#deleteJoin

[code-tips]

DELETE Multitabla (MySQL)

DELETE JOIN

INNER JOIN

DELETE T1, T2 FROM T1 INNER JOIN T2 ON T1.key = T2.key WHERE condition;

LEFT JOIN

DELETE T1 FROM T1 LEFT JOIN T2 ON T1.key = T2.key WHERE T2.key IS NULL;