--查询显示不存在员工的部门号
select d.deptno from emp e, dept d where e.deptno(+)= d.deptno group by d.deptno having count(e.empno)=0;
我这样改,报错了
select d.deptno from emp e join dept d right outer on(emp.deptno = dept.deptno) group by d.deptno having count(e.empno)=0;
怎么写呀???
select d.deptno from emp e, dept d where e.deptno(+)= d.deptno group by d.deptno having count(e.empno)=0;
我这样改,报错了
select d.deptno from emp e join dept d right outer on(emp.deptno = dept.deptno) group by d.deptno having count(e.empno)=0;
怎么写呀???
修改为
right join dept d right 如
select * from fudl_temp a right join fudl_fs b on a.a=b.dbname
group by d.deptno
having count(e.empno)=0;
from emp "e", dept "d"
where "e".deptno= "d".deptno
group by "d".deptno
having count("e".empno)=0;select "d".deptno
from emp "e" join dept "d"
on("e".deptno = "d".deptno)
group by "d".deptno
having count("e".empno)=0;