[ORACLE] 조인 예제

-- 이너조인 
SELECT EMP.DEPTNO, EMPNO, ENAME, DNAME
FROM EMP INNER JOIN DEPT
ON EMP.DEPTNO = DEPT.DEPTNO;

--이너조인 이름 줄이기
SELECT E.DEPTNO, EMPNO, ENAME, DNAME
FROM EMP E INNER JOIN DEPT D
ON E.DEPTNO = D.DEPTNO;

-- 그냥 조인
SELECT E.DEPTNO, EMPNO, ENAME, DNAME
FROM EMP E JOIN DEPT D
ON E.DEPTNO = D.DEPTNO;

--레프트 아우터 조인
SELECT ENAME, EMPNO, D.DEPTNO, DNAME
FROM DEPT D LEFT OUTER JOIN EMP E
ON D.DEPTNO = E.DEPTNO
ORDER BY DEPTNO;

-- 라이트 아우터 조인
SELECT ENAME, EMPNO, D.DEPTNO, DNAME
FROM EMP E  RIGHT OUTER JOIN DEPT D
ON D.DEPTNO = E.DEPTNO
ORDER BY DEPTNO;