What is a cross join?

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.

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

rows of first table multiplied by rows of second

it's use for merge two table