How many records will be there in the result set of a CROSS JOIN?
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.
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