How can I delete data FROM two tables? SELECT * FROM 'liao _ addonarticle', region = liao_archives.idandliao_addonarticle.body = '': why can't I delete data FROM two tables?
SELECT * FROM 'liao _ addonarticle ', liao_archives where liao_addonarticle.aid = liao_archives.id and liao_addonarticle.body = ''data is generated.
I have written either of the following statements. How can I change it?
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 = '')
------ Solution --------------------
SQL code
DELETE 'liao _ addonarticle', 'liao _ archives 'FROM 'liao _ addonarticle' left join 'liao _ archives' ON region = liao_archives.id WHERE liao_addonarticle.body =''
