SELECT * FROM QuestionInfo
WHERE ID != (select QuestionID from Exam)
SELECT * FROM QuestionInfo
WHERE ID not in (select QuestionID from Exam)
!= 有数据
not in 没有数据
但各类文档都说 2者是等价
SELECT * FROM QuestionInfo
WHERE ID != (select QuestionID from Exam)
SELECT * FROM QuestionInfo
WHERE ID not in (select QuestionID from Exam)
!= 有数据
not in 没有数据
但各类文档都说 2者是等价