Cross Join

Optimizing SQL Database Performance

Optimizing Database Performance

Cross Join

The Cross Join logical operator joins each row from the first (top) input with each row from the second (bottom) input.

See Also

Using Cross Joins