Select e.empno as employee, e.deptno as department, d.loc as location from emp e,dept d where e.deptno= d.deptno;