--两个字段同时不在某张表的sql SELECT * FROM 表B WHERE B.a NOT IN (SELECT DISTINCT A.a FROM 表A) AND B.b NOT IN (SELECT DISTINCT A.b FROM 表A) --使用字段 查询出来的其实是不同记录(正确) --A表某个字段同时不在B表跟C表 SELECT * FROM 表A WHERE A.a NOT IN (SELECT DISTINCT B.a FROM 表B) AND A.a NOT IN (SELECT DISTINCT C.a FROM 表c) --不同记录与不同字段 a.id not in b.X between c.X