INNER JOIN

Syntax:

SELECT...FROM table_reference1
  INNER JOIN table_reference2 join_condition
					

Description: Performs an inner join as part of a SELECT statement. An inner join is the default type of join, in which rows of table_reference1 are crossed with rows of table_reference2 where join_condition is met.

table_reference is either a table name, or uses an alias to that table, in the format table_name AS alias_name.

join_reference defines the relationship used in the join and is either ON conditional_expression or USING (column_list).

Description in: Day 9

See also: CROSS JOIN, INNER JOIN, LEFT JOIN, NATURAL JOIN