sql-server - T-SQL : [column] not like [any value from another select]

Question

我的表 shop 有一个 Email 列。

我还有另一个表 Unsubscribed，其中包含 EmailPattern 列。

如何只选择 Email 列与 Unsubscribed 表中的任何 EmailPattern 值不匹配的商店？

例子:

退订有这些记录:

aaa
bbb
ccc

我期望这样的结果:

select * 
from Shop 
where Email not like "%aaa%" 
  and Email not like "%bbb%" 
  and Email not like "%ccc%"

Answer 1

Select *
From shop
Where not exists (
  Select 1
  From unsubscribed
  Where shop.email like '%' + unsubcribed.emailpattern + '%'
)