What is a cross join?

Answer 1

Cartesian product of two tables. (N*M)
If table1 has N number of rows and table2 has M number of rows then result set will have N*M number of rows.

Answer 2

number of rows in the first table multiplied by number of rows in the second table.

Answer 3

rows of first table multiplied by rows of second

Answer 4

it's use for merge two table