MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual :: 12.2.1 DELETE Syntax

The syntax for multiple-table DELETE statements that use table aliases changed between MySQL 4.0 and 4.1. In MySQL 4.0, you should use the true table name to refer to any table from which rows should be deleted: DELETE test FROM ...

dev.mysql.com