select e.ename, e.job,d.loc ,d.dname FROM EMP e , dept d where e.deptno = d.deptno and d.deptno =30 order by d.deptno OR select e.ename, e.job,d.loc ,d.dname FROM EMP e , dept d where d.deptno = e.deptno and d.deptno =30 order by e.deptno
select e.ename, e.job,d.loc ,d.dname FROM EMP e , dept d where e.deptno = d.deptno and d.deptno =30 order by d.deptno
OR
select e.ename, e.job,d.loc ,d.dname FROM EMP e , dept d where d.deptno = e.deptno and d.deptno =30 order by e.deptno