CROSS JOIN in SQL

CROSS JOIN in SQL — a practical guide to SQL CROSS JOIN with clear examples you can reuse in real projects.

SQL Tutorial Series (52/100). Prefer one article? Read the complete SQL tutorial.

Short description

Useful for generating combinations — dangerous if accidental.

Cross join

SELECT s.size, c.color
FROM sizes s
CROSS JOIN colors c;