select emp.ename,emp.deptno, emp.job,dept.loc ,dept.dname FROM EMP inner join dept on emp.deptno = dept.deptno where emp.deptno = 30