codice:
Multiple-table syntax: 

DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
    tbl_name[.*] [, tbl_name[.*]] ...
    FROM table_references
    [WHERE where_condition]
quindi niente uso di JOIN forma ansi (inner join) ma solo forma theta (from a, b) ed equi-join in where. Senza l'uso di alias.

codice:
DELETE tab1
from tab1, tab2
where tab1.id = tab2.id