Syntax:
SELECT...FROM table_reference1 LEFT JOIN table_reference2 join_condition
Description: Performs a left join as part of a SELECT statement. A left join is a join in which all rows in the left table table_reference1 are returned (subject to any WHERE condition); wherever these rows match with rows of table_reference2 through a join_condition, values from the right table appear in the resultset, or NULL otherwise.
table_reference either is a table name or uses an alias to that table, in the format table_name AS alias_name.
join_condition 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 LEFT JOIN, RIGHT JOIN
18.217.199.122