[sqld] 노랭이책(개정판) - 46번 문제(p.60)

1. 예제 테이블

예제쿼리.txt

0.00MB

SELECT A, B, X.C, D, E
FROM EMP X LEFT OUTER JOIN DEPT Y
ON (X.C = Y.C);

         A B          C                   D          E
---------- ---------- ---------- ---------- ----------
         3 d          w                   1         10
         1 b          w                   1         10
         5 y          y

SELECT A, B, X.C, D, E
FROM EMP X FULL OUTER JOIN DEPT Y
ON (X.C = Y.C);

         A B          C                   D          E
---------- ---------- ---------- ---------- ----------
         3 d          w                   1         10
         1 b          w                   1         10
                                          4         11
                                          2         22
         5 y          y

SELECT A, B, X.C, D, E
FROM EMP X RIGHT OUTER JOIN DEPT Y
ON (X.C = Y.C);

         A B          C                   D          E
---------- ---------- ---------- ---------- ----------
         1 b          w                   1         10
         3 d          w                   1         10
                                          4         11
                                          2         22