求问一个类似取反的SQL查询

[myricemeli]

我想在数据库中查找符合以下三种任意条件的记录
条件1：`Number` = 'a' AND `Text` = '2017'
条件2：`Number` = 'b' AND `Text` = '2017'
条件3：`Number` = 'c' AND `Text` = '2017'

比如使用如下语句

SELECT * FROM `Table_1` WHERE (`Number` = 'a' AND `Text` = '2017') OR (`Number` = 'b' AND `Text` = '2017') OR (`Number` = 'c' AND `Text` = '2017');

查找完成后，如何获取不符合以上任意条件的记录，我的意思不是使用Not取反，而是得到一个列表，列表中显示的是上面三种条件中那个没有查询到。

[ACMAIN_CHM]

select * from t where (col1,col2) not in (select ...

[rucypli]

引用 1 楼 ACMAIN_CHM 的回复:

select * from t where (col1,col2) not in (select ...