SQLite not in 无法查询数据

 

SELECT * FROM QuestionInfo
WHERE  ID != (select QuestionID from Exam)

SELECT * FROM QuestionInfo
WHERE  ID not in  (select QuestionID from Exam)

！= 有数据

not in 没有数据

但各类文档都说 2者是等价