These options enable the FROM clause to specify that multiple tables be joined.
- joined_table
- Name of a joined table, which can be either a single table name with optional alias name, or a joined table, indicating nested joins.
- INNER
- Join in which qualifying rows from one table are combined with qualifying rows from another table according to some join condition.
- OUTER
- Join in which qualifying rows from one table that do not have matches in the other table, are included in the join result along with the matching rows from the inner join. The rows from the first table are extended with nulls.
- LEFT OUTER
- Outer join with the table that was listed first in the FROM clause.
- RIGHT OUTER
- Outer join with the table that was listed second in the FROM clause.
- FULL OUTER
- Rows are returned from both tables
- JOIN
- Introduction to the name of the second table to include in the join.
- ON search_condition
- One or more conditional expressions, including scalar subqueries, that must be satisfied by the result rows.
- CROSS JOIN
- Unconstrained, or Cartesian, join. Returns all rows from all tables specified in the FROM clause. Two joined tables can be cross joined.
- single_table
- Name of a single base or derived table or view on a single table to be cross joined with joined_table.