Joins

  • A SQL JOIN combines records from two tables.
  • A JOIN locates related column values in the two tables.
  • A query can contain zero, one, or multiple JOIN operations.
  • INNER JOIN is the same as JOIN; the keyword INNER is optional.

Inner Join

Different types of JOINs

  • (INNER) JOIN: Select records that have matching values in both tables.
  • LEFT (OUTER) JOIN: Select records from the first (left-most) table with matching right table records.
  • RIGHT (OUTER) JOIN: Select records from the second (right-most) table with matching left table records.
  • FULL (OUTER) JOIN: Selects all records that match either left or right table records.

Inner Join

All INNER and OUTER keywords are optional.

Details about the differences between these JOINs are available in subsequent tutorial pages.

results matching ""

    No results matching ""