SQL> select ename, emp.deptno, dept.deptno, dname from emp, dept where emp.deptno=dept.deptno; ENAME DEPTNO DEPTNO DNAME ---------- ---------- ---------- -------------- SMITH 20 20 RESEARCH ALLEN 30 30 SALES WARD 30 30 SALES JONES 20 20 RESEARCH MARTIN 30 30 SALES BLAKE 30 30 SALES CLARK 10 10 ACCOUNTING SCOTT 20 20 RESEARCH KING 10 10 ACCOUNTING TURNER 30 30 SALES ADAMS 20..