记录一下:
select * from dept_xxx a where a.deptno not in (select distinct b.deptno from emp_xxx b where b.deptno is not null )
not in(列表),列表如果存在null,那么将无返回结果。
记录一下:
select * from dept_xxx a where a.deptno not in (select distinct b.deptno from emp_xxx b where b.deptno is not null )
not in(列表),列表如果存在null,那么将无返回结果。