Display ename,dname even if there are no employees working in a particular department(use outer join).

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 1185
select ename,dname from emp,dept where emp.deptno=dept.deptno(+)

Comments or Responses

Login to post response