2

A CROSS JOIN or CROSS APPLY will return a 'Cartesian product' or 'cross product' (i.e.: every combination of rows from the two tables.) In this case, those operators are functionally equivalent. -- set up our tables CREATE TABLE Customer ( CustomerNumber int ) CREATE TABLE Product ( Product varchar(15) ) INSERT INTO Customer ( CustomerNumber ) ...


Only top voted, non community-wiki answers of a minimum length are eligible