http://www.perlmonks.org?node_id=891251


in reply to MySQL DELETE with INNER JOIN

mysql> DELETE ab, b -> FROM Authors AS a INNER JOIN AuthorArticle AS ab ON a.AuthID=ab +.AuthID -> INNER JOIN Articles AS b ON ab.ArticleID=b.ArticleID -> WHERE AuthorLastName='Tom'; Query OK, 0 rows affected (0.01 sec)
You may want to consider an example that actually deletes something.

But don't post it here. This site is about Perl, not MySQL. The MySQL documentation explains it in detail, giving alternative syntaxes as well.