select empno, ename, dname, loc
from emp, dept
where emp.deptno = dept.deptno
/