Joining Tables

EMP

DEP

SELECT e.empno AS Number, e.ename AS Name, d.dname AS Department

FROM emp e, dep d

WHERE e.deptno = d.deptno;

Previous slide

Next slide

Back to first slide

View graphic version