select GLH from sde.zd_nh;
得到488个记录,且GLH不重复SELECT GLH FROM SDE.ZD_NH WHERE GLH IN (SELECT ZDID FROM A_ZDLY);
得出471个记录SELECT GLH FROM SDE.ZD_NH WHERE GLH NOT IN (SELECT ZDID FROM A_ZDLY);
为什么执行下来是 no rows returned呢??
为什么不是488-471=17个记录吗??如何才能找出不在A_ZDLY表里的那17个记录?
得到488个记录,且GLH不重复SELECT GLH FROM SDE.ZD_NH WHERE GLH IN (SELECT ZDID FROM A_ZDLY);
得出471个记录SELECT GLH FROM SDE.ZD_NH WHERE GLH NOT IN (SELECT ZDID FROM A_ZDLY);
为什么执行下来是 no rows returned呢??
为什么不是488-471=17个记录吗??如何才能找出不在A_ZDLY表里的那17个记录?
是这样查的吗
minus
SELECT GLH FROM SDE.ZD_NH WHERE GLH IN (SELECT ZDID FROM A_ZDLY);看一下结果是怎样的
SELECT GLH FROM SDE.ZD_NH t1 Where Not Exists (Select 1 From A_ZDLY t2 Where t2.ZDID = t1.GLH);