CROSS JOIN

Take the cartesian product of two tables.

CROSS JOIN produces every combination of rows from two tables. The row count is the product.

SELECT c.name, p.name
FROM customers c
CROSS JOIN products p;

This query gives every customer-product pair.

c.name, p.name is selected from customers c. products p is joined, producing every possible pair.

CROSS JOIN — details

CROSS JOIN has no ON condition. On large tables the result explodes; use with care.

For example, CROSS JOIN of two 100-row tables produces 10,000 rows, which is why an accidental cross join on large tables is expensive.

Join customers with products using CROSS JOIN.

Show example solution

SELECT c.name, p.name
FROM customers c
CROSS JOIN products p;

Add CROSS JOIN

SELECT c.name, p.name
FROM customers c
____ products p;

Show answer

SELECT c.name, p.name
FROM customers c
CROSS JOIN products p;