如果列b中存在另一个值，则过滤列A

Question

我有两列

<表类> 存储代码tbody><<tr>Store1。DD101Store2。德103Store2。DD103Store1。DD105Store2。DD107

SELECT [Store]
,[Code]
FROM [dbo].[Store]
WHERE not (Store like '%DD' and Code in ('101', '103'))

在您给出的示例中，您可以将逻辑从AND更改为OR

SELECT * FROM table  
WHERE Code NOT IN (101,103) OR Store NOT LIKE '%DD'

SELECT * FROM table
WHERE Store NOT LIKE '%DD' OR Code NOT IN ('101', '103')