INNER JOIN
1 2 3 |
SELECT <fields> FROM A INNER JOIN B ON (A.key = B.key) |
LEFT JOIN
1 2 3 |
SELECT <fields> FROM A LEFT JOIN B ON (A.key = B.key) |
RIGHT JOIN
1 2 3 |
SELECT <fields> FROM A RIGHT JOIN B ON (A.key = B.key) |
OUTER JOIN
1 2 3 |
SELECT <fields> FROM A FULL OUTER JOIN B ON (A.key = B.key) |
LEFT ONLY JOIN
1 2 3 4 |
SELECT <fields> FROM A LEFT JOIN B ON (A.key = B.key) WHERE B.key IS NULL |
RIGHT ONLY JOIN
1 2 3 4 |
SELECT <fields> FROM A RIGHT JOIN B ON (A.key = B.key) WHERE A.key IS NULL |
LEFT ONLY AND RIGHT ONLY JOIN
1 2 3 4 |
SELECT <fields> FROM A RIGHT JOIN B ON (A.key = B.key) WHERE A.key IS NULL AND B.key IS NULL |