请问sqlite怎样Delete 和inner Join 一起使用
DELETE from 表1 INNER JOIN 表2 ON 表2.Id=表1.nid where 表2.word='123'
这样写有语法问题。
sqlite delete inner join
------解决方案--------------------
try
DELETE from a from 表1 a INNER JOIN 表2 b ON a.Id=b.nid where b.word='123