CROSS JOIN examples are tiny finite-table transforms; SQL dialect completeness, type coercion, optimizer behavior, execution cost, indexing, and database-product claims are out of scope.
Every left row pairs with every right row: left table Every left row pairs with every right row: left table color red blue Every left row pairs with every right row: right table Every left row pairs with every right row: right table size S M L pair grid pair grid leftSource rightSource leftValues rightValues output 0 0 [red] [S] [red, S] 0 1 [red] [M] [red, M] 0 2 [red] [L] [red, L] 1 0 [blue] [S] [blue, S] 1 1 [blue] [M] [blue, M] 1 2 [blue] [L] [blue, L] CROSS JOIN output rows CROSS JOIN output rows left.color right.size red S red M red L blue S blue M blue L CROSS JOIN facts CROSS JOIN facts fact value leftRowCount 2 rightRowCount 3 pairCount 6 outputRowCount 6 outputColumnCount 2 rowOrder left_source_then_right_source emptySideProduct no