select e.empno
,      e.ename
,      e.job
,      e.mgr
,      e.hiredate
,      e.sal
,      e.comm
,      d.deptno
,      d.dname
,      d.loc
from   emp  e
,      dept d
where  e.deptno = d.deptno