sql - 从联接表中删除SQL无效

下面返回一个语法错误问题。
在网上搜遍了，我不明白为什么。有什么想法吗？

delete Tracks
from tracks
left join releases
on tracks.label_id=releases.label_id
where tracks.label_id = 185
and releases.id = 4394
and tracks.position = 1
and tracks.name != 'Da Antidote';

语法错误在第1行。

最佳答案

如果我没记错的话，Postgres不允许加入DELETE，但是您可以使用USING关键字来代替described in the documentation：

DELETE FROM Tracks
USING releases
WHERE tracks.label_id=releases.label_id
AND tracks.label_id = 185
AND releases.id = 4394
AND tracks.position = 1
AND tracks.name != 'Da Antidote';

关于sql - 从联接表中删除SQL无效，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/18054475/