Question

Sql delete删除语句问题？

delete a,b,c from a表 as a
INNER JOIN b表 as b on b.id=a.id
INNER JOIN c表 as c on c.id=b.id
where c.id='123'

Answer 1

参考如下：

改为如下语句试下：

delete a,b,c from a表 as a
INNER JOIN b表 as b
INNER JOIN c表 as c
where b.id=a.id and c.id=b.id and  c.id='123'