How many records will be there in the result set of a CROSS JOIN?

Cross join :Cross Joins produce results that consist of every combination of rows from two or more tables. That means if table A has 3 rows and table B has 2 rows, a CROSS JOIN will result in 6 rows. There is no relationship established between the two tables

IF you have 5 rows in table A. and 8 rows in tables C. then the result will be 40 rows will be in cross jo

Result count is same as cartesian product of results from two table.

The Cartesian Product is a multiplication operation in the set theory that generates all ordered pairs of the given sets.