| A | B |
|---|
| NATURAL JOIN | joins two tables based on the same column name. |
| ON Clause | allows a natural join based on an arbitrary condition or to specify columns to join |
| CROSS JOIN | returns the Cartesian product from two tables. |
| RIGHT OUTER JOIN | performs a join on two tables, retrieves all the rows in the Right table even if there is no match in the Left table. |
| USING Clause | performs an equijoin based on the same specified column name |
| INNER JOIN | is a join of two tables returning only matched rows. |
| FULL OUTER JOIN | performs a join on two tables, retrieves all the rows in the Left table, even if there is no match in the Right table. It also retrieves all the rows in the Right table, even if there is no match in the Left table. |
| LEFT OUTER JOIN | performs a join on two tables, retrieves all the rows in the Left table even if there is no match in the Right table. |
