| Complete Syntax | Common Usage |
|---|---|
| FULL INNER JOIN | INNER JOIN or simply JOIN |
| FULL OUTER JOIN | FULL JOIN |
| LEFT OUTER JOIN | LEFT JOIN |
| RIGHT OUTER JOIN | RIGHT JOIN |
| CROSS JOIN | CROSS JOIN |
RIGHT INNER JOIN and LEFT INNER JOIN are non-existent syntax because results are the same as in INNER JOIN.
