Sams Teach Yourself MySQL in 21 Days, Second Edition

NATURAL JOIN

Syntax:

SELECT...FROM table_reference1
  NATURAL JOIN table_reference2
					

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

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

Description in: Day 9

See also: INNER JOIN, NATURAL LEFT JOIN