1
2
3
4
DELETE table1, table2, table3 FROM table1
LEFT JOIN table2 USING(field)
LEFT JOIN table3 USING(field)
WHERE table1.field = 'value'