Utilizor

MySQL CROSS JOIN

Cartesian product.

MySQL CROSS JOIN Keyword

The CROSS JOIN keyword returns all records from both tables (table1 and table2).

It generates a Cartesian product: matching every row from the first table with every row from the second table.

Note: CROSS JOIN can potentially produce very large result sets!

Example

SELECT * FROM Customers CROSS JOIN Orders;