CROSS JOIN

Syntax:

SELECT...FROM table_reference1
  CROSS JOIN table_reference2 join_condition

Description: Performs a cross join as part of a SELECT statement. In a cross join, every row of table_reference1 is crossed with every row of table_reference2.

Description in: Day 9

See also: INNER JOIN

Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial