删除两个表中的数据 怎么删除不了
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 codedelete `liao_addonarticle`,`liao_archives` from `liao_addonarticle` left join `liao_archives` on liao_addonarticle.aid=liao_archives.id where liao_addonarticle.body=''