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