Sams Teach Yourself MySQL in 21 Days, Second Edition

NATURAL LEFT JOIN

Syntax:

SELECT...FROM table_reference1
  NATURAL LEFT JOIN table_reference2
					

Description: Performs a left join as part of a SELECT statement, crossing rows of table_reference1 with rows of table_reference2, in all columns where the column names are identical in both tables. (Therefore, this is the same as a LEFT JOIN with a USING clause that lists all columns that exist in both tables.)

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

Description in: Day 9

See also: LEFT JOIN, NATURAL JOIN