LEFT INNER JOIN
SELECT <columns>
FROM Table_A A LEFT INNER JOIN TABLE_B
ON A.Key = B.Key

LEFT INNER JOIN WITH NULL
SELECT <columns>
FROM Table_A A LEFT INNER JOIN TABLE_B
ON A.Key = B.Key
WHERE B.Key IS NULL

RIGHT INNER JOIN
SELECT <columns>
FROM Table_A A RIGHT INNER JOIN TABLE_B
ON A.Key = B.Key

RIGHT INNER JOIN WITH NULL
SELECT <columns>
FROM Table_A A RIGHT INNER JOIN TABLE_B
ON A.Key = B.Key
WHERE A.Key IS NULL

INNER JOIN
SELECT <columns>
FROM Table_A A INNER JOIN TABLE_B
ON A.Key = B.Key

FULL OUTHER JOIN
SELECT <columns>
FROM Table_A A FULL OUTHER JOIN TABLE_B
ON A.Key = B.Key

FULL OUTHER JOIN WITH NULL
SELECT <columns>
FROM Table_A A FULL OUTHER JOIN TABLE_B
ON A.Key = B.Key
WHERE A.Key IS NULL OR B.Key IS NULL
