oracle外连接

select d.deptno,d.dname,count(e.empno)
from emp e,dept d
where e.deptno(+)=d.deptno //左外连接  e.deptno=d.deptno(+) 右外连接
group by d.deptno,d.dname
order by 1