CROSS JOIN

A join returning every possible pairing of rows from two table expressions.

What is CROSS JOIN in a relational database?

CROSS JOIN — A join returning every possible pairing of rows from two table expressions.

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

Level: Apprentice · More Database terms at this level

Updated