刪除兩個表中的資料 如何刪除不了

刪除兩個表中的資料 怎麼刪除不了
SELECT * FROM `liao_addonarticle`,liao_archives where liao_addonarticle.aid=liao_archives.id and liao_addonarticle.body='' 是有資料出來的


我寫了下面的兩條語句 都不行。 該怎麼改的呢？

delete FROM `liao_addonarticle`,liao_archives where liao_addonarticle.aid=liao_archives.id and liao_addonarticle.body=''

delete from (SELECT * FROM `liao_addonarticle`,liao_archives where liao_addonarticle.aid=liao_archives.id and liao_addonarticle.body='')



------解決方案--------------------

SQL code

DELETE `liao_addonarticle`,`liao_archives` FROM `liao_addonarticle` LEFT JOIN `liao_archives` ON liao_addonarticle.aid=liao_archives.id WHERE liao_addonarticle.body=''
