17,377
社区成员
发帖
与我相关
我的任务
分享
select a.*
from emp a ,emp_bill b
where a.emp_no=b.emp_no(+)
and b.emp_no is null
select a.*
from emp a ,emp_bill b
where a.emp_no=b.emp_no(+)
and NVL(b.emp_no, '1') = '1'
SELECT A.* FROM EMP A, EMP_BILL B WHERE LNNVL(A.EMP_NO = B.EMP_NO);
SELECT *
FROM EMP A
WHERE NOT EXISTS (SELECT 1 FROM EMP_BILL B WHERE B.EMP_NO = A.EMP_NO)
select *
from emp a
where not exists (select 1
from emp_bill b
where b.emp_no=a.emp_no)
select a.*
from emp a ,emp_bill b
where a.emp_no=b.emp_no(+)
and b.emp_no is null
select *
from emp a
where not exists (select 1
from emp_bill b
where b.emp.no=a.emp_no)
select *
from emp a
where no exists (select 1
from emp_bill b
where b.emp.no=a.emp_no)