让我举例解释一下.请考虑下表:
Customer Id | Food ------------+--------- 1 | Pizza 1 | Burger 1 | Hot Dog 2 | Milkshake 2 | Burger 3 | Pizza
我想删除那些从未订购过Pizza的客户的所有记录.所以,我应该留下这个(客户#2删除):
Customer Id | Food ------------+--------- 1 | Pizza 1 | Burger 1 | Hot Dog 3 | Pizza
我知道我可以做一个NOT IN但性能很糟糕.