Cross join (also called cartesian join) of two (or more) tables returns the so-called cartesian product of the sets of records from all tables.
It means that cross join matches every record in every table with every record in all other tables.
Therefore, total number of records in the result set is equal to multiplication of numbers of records in all tables over which the query is performed (table1_count * table2_count * ... * tableN_count).
Cross join example query:
SELECT *
FROM table1, table2, table3
It will return the result set consisting of all possible combinations of columns from all source tables.
Login in to like
Login in to comment