JOIN overview
JOIN combines rows from two or more tables. The examples below show matching rows and unmatched rows for the main join types.
LEFT JOIN
Query |
Matching rows |
|---|
SELECT select_list FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key
|
|
SELECT select_list FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key WHERE B.Key IS NULL
|
|
RIGHT JOIN
Query |
Matching rows |
|---|
SELECT select_list FROM TableA A RIGHT JOIN TableB B ON A.Key = B.Key
|
|
SELECT select_list FROM TableA A RIGHT JOIN TableB B ON A.Key = B.Key WHERE A.Key IS NULL
|
|
INNER JOIN
Query |
Matching rows |
|---|
SELECT select_list FROM TableA A INNER JOIN TableB B ON A.Key = B.Key
|
|
FULL JOIN
Query |
Matching rows |
|---|
SELECT select_list FROM TableA A FULL OUTER JOIN TableB B ON A.Key = B.Key
|
|
SELECT select_list FROM TableA A FULL OUTER JOIN TableB B ON A.Key = B.Key WHERE A.Key IS NULL OR B.Key IS NULL
|
|
Last updated on
