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
3.144.97.187