JOIN MORE THAN 2 TABLES
=========================
SELECT E.ENAME,E.SAL,D.DEPTNO,A.LOC FROM
EMP E JOIN DEPT D
ON E.DEPTNO=D.DEPTNO
JOIN
ADDR A
ON D.LOC=A.LOC
WITHOUT JOIN
=================
SELECT E.ENAME,E.SAL,D.DEPTNO,A.LOC FROM
EMP E,DEPT D,ADDR A
WHERE
E.DEPTNO=D.DEPTNO
AND
D.LOC=A.LOC
No comments:
Post a Comment