今天发现一个问题,当not in (sql) ,如果sql查询是null指的话 最后结果会返回null
举例:
SELECT id,DefineSymbol FROM table1
WHERE id NOT IN (SELECT DISTINCT ActionId FROM table2 )
返回结果为null
修改之后:
SELECT id,DefineSymbol FROM table1
WHERE id NOT IN (SELECT DISTINCT ActionId FROM table2 WHERE ActionId IS NOT NULL)
返回理想结果