Cross Join

Keyword CROSS JOIN

The CROSS JOIN keyword returns the Cartesian product of rows from the tables in the join. In other words, it combines each row from the first table with each row from the second table.

Syntax:

SELECT ... FROM table1 CROSS JOIN table2 [USING columns | ON condition]

AlaSQL supports comma-separated tables in the CROSS JOIN syntax:

SELECT * FROM table1, table2 CROSS JOIN table3

See also: JOIN