select xxzqdm as zqdm
from szxx
where xxzqdm not in (select fzqdm from jjhzxx)select xxzqdm as zqdm from szxx MINUS (select fzqdm from jjhzxx)请问这两个语句的查询结果为什么不一样呢?
from szxx
where xxzqdm not in (select fzqdm from jjhzxx)select xxzqdm as zqdm from szxx MINUS (select fzqdm from jjhzxx)请问这两个语句的查询结果为什么不一样呢?
2、第二结果集如果有空值也会影响