CROSS JOIN

A join with no pairing rule, which pairs every row of one table with every row of the other.

In more detail

Six rows crossed with eight rows give forty-eight. Written on purpose, it builds a complete grid, such as every status with every category, so missing combinations show as zero instead of disappearing. Write CROSS JOIN in full so a reader knows it is intended.

Related terms

Taught in

References