The CARTESIAN JOIN or CROSS JOIN returns the Cartesian product of the sets of records from two or more joined tables. Thus, it equates to an inner join where the join-condition always evaluates to either True or where the join-condition is absent from the statement.
The main idea of the CROSS JOIN is that it returns the Cartesian product of the joined tables. In the following tip, we will briefly explain the Cartesian product.
The basic syntax of the CARTESIAN JOIN or the C
ROSS JOIN is as follows −
SELECT table1.column1, table2.column2... FROM table1, table2 [, table3 ]