select a.empno from emp a where a.empno not in(select empno from emp1 where job=´SALE´);
select a.empno from emp a ,emp1 b where a.empno=b.empno(+) and b.empno is null and b.job=´SALE´;
这两个SQL的结果是一样吗??
...全文
693打赏收藏
请教个SQL的问题!
select a.empno from emp a where a.empno not in(select empno from emp1 where job=´SALE´); select a.empno from emp a ,emp1 b where a.empno=b.empno(+) and b.empno is null and b.job=´SALE´; 这两个SQL的结果是一样吗??