Cartesian Product

The relation containing every possible concatenation of a tuple from each input relation.

What is Cartesian Product in a relational database?

Cartesian Product — The relation containing every possible concatenation of a tuple from each input relation.

SELECT size.name, color.name
FROM size
CROSS JOIN color;

Level: Master · More Database terms at this level

Updated September 27, 2026