[JOIN] SQL JOIN Diagram 과 Query문 정리 - ANSI, ORACLE

• INNER JOIN 내부 조인

INNER JOIN

SELECT
    [Columns]
FROM
    TableA A
INNER JOIN
    TableB B
ON
    A.Key = B.Key

 

• LEFT EXCLUSIVE JOIN 좌측 배타 조인

LEFT EXCLUSIVE JOIN

SELECT
    [Columns]
FROM
    TableA A
LEFT OUTER JOIN
    TableB B
ON
    A.Key = B.Key
WHERE
    B.Key IS NULL

 

• LEFT INCLUSIVE JOIN 좌측 포괄 조인

LEFT INCLUSIVE JOIN

SELECT
    [Columns]
FROM
    TableA A
LEFT OUTER JOIN
    TableB B
ON
    A.Key = B.Key

 

• RIGHT EXCLUSIVE JOIN 우측 배타 조인

RIGHT EXCLUSIVE JOIN

SELECT
    [Columns]
FROM
    TableA A
RIGHT OUTER JOIN
    TableB B
ON
    A.Key = B.Key
WHERE
    A.Key IS NULL

 

• RIGHT INCLUSIVE JOIN 우측 포괄 조인

RIGHT INCLUSIVE JOIN

SELECT
    [Columns]
FROM
    TableA A
RIGHT OUTER JOIN
    TableB B
ON
    A.Key = B.Key

 

• FULL OUTER EXCLUSIVE 전체 외부 배타 조인

FULL OUTER EXCLUSIVE

SELECT
    [Columns]
FROM
    TableA A
FULL OUTER JOIN
    TableB B
ON
    A.Key = B.Key
WHERE
    A.Key IS NULL OR B.Key IS NULL

 

• FULL OUTER INCLUSIVE 전체 외부 포괄 조인

FULL OUTER INCLUSIVE

SELECT
    [Columns]
FROM
    TableA A
FULL OUTER JOIN
    TableB B
ON
    A.Key = B.Key