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