Mysql delete inner join ainult ühest tabelist
Lihtsalt igaks juhusk panen kirja mysql delete query, kui on vaja kustutada ühest tabelist:
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 AuthorFirstName='Tom';