查找另一个表后从一个表中删除 - SQL

Question

嗨
我有两个表

Invited

• UID [pk]

Active

• UID [pk]

我想从 Active 中存在的 Invited 中删除 UID 表
我可以通过加入来做到这一点还是唯一的方法是使用 NOT IN 或 IN ？

Answer 1

是的，您可以使用IN。

从 UID 所在的受邀者中删除（从活动中选择 UID）

或者，如果您愿意，您可以使用加入

Delete i
From Invited as i
Join Active as a on i.UID = a.UID 

Answer 2

DELETE FROM `Invited` WHERE Invited.UID IN ( SELECT UID FROM `Active`)

或者，为了提高性能：

DELETE i FROM `Invited` AS i WHERE EXISTS ( SELECT 1 FROM `Active` WHERE Active.UID = i.UID )