AI engineering glossary · SQL databases
What is CROSS JOIN?
CROSS JOIN (also called Cartesian join): A join that pairs every row of one table with every row of another, with no condition, giving m times n rows. It is useful for generating combinations but dangerous when forgotten between large tables.
CROSS JOIN: an example
Cross joining 3 sizes with 4 colours produces 12 product variants.
Related terms
- Join
- INNER JOIN
- Cartesian product
More SQL databases terms
Where you learn it
CROSS JOIN is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.