If the first table has two rows and the second table has three rows, how many rows will result from a cross join?

Question

Accepted Answer

A cross join combines all rows from two tables, resulting in a Cartesian product of the rows.

A cross join between a table with 2 rows and another with 3 rows results in 2 * 3 = 6 rows.
Example: Table A has rows (A1, A2) and Table B has rows (B1, B2, B3).
The result of the cross join will be: (A1, B1), (A1, B2), (A1, B3), (A2, B1), (A2, B2), (A2, B3).
Cross joins are useful for generating combinations of data.

Accepted Answer

6 rows came because of rows of first table get multiply with all rows of the second table