sqlite - SQlite删除内部联接

Question

我已经阅读了很多其他答案，但无法正常工作！

select * from invTypes
inner join invGroups on invtypes.groupID = invgroups.groupID
where invGroups.categoryID = 25;

如果类别ID匹配到25，我只是想从invTypes中删除记录

非常感谢您的协助

我已经尝试过：

delete from invTypes
inner join invGroups on invtypes.groupID = invgroups.groupID
where invGroups.categoryID = 25;

给出错误：
在“内部”附近：语法错误：

DELETE FROM invTypes
WHERE groupID in ( SELECT groupID FROM invGroups INNER JOIN invTypes ON (invGroups.groupID = invTypes.groupID) 
WHERE invGroups.categoryID = 25);

给出：
列名不明确：groupID：从invTypes中删除
WHERE invGroups.categoryID = 25）中的groupID（从invGroups内连接中选择groupID INNER JOIN invTypes ON（invGroups.categoryID = invTypes.categoryID）。

Answer 1

您可以将delete与where子句一起使用

delete from invTypes
where groupId in ( select groupId from invGroups where CategoryID =25)