in reply to MySQL DELETE with INNER JOIN
You may want to consider an example that actually deletes something.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)
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.
In Section
Meditations