Combine Every Pair of Rows

CROSS JOIN combines each left-side row with every right-side row. N left rows and M right rows produce N × M rows. Combining two tables without a join condition produces the same set of all combinations as a CROSS JOIN.