CARTESIAN JOIN or CROSS JOINThe CARTESIAN JOIN or CROSS JOIN returns the Cartesian product of the sets of records from the two or more joined tables. Thus, it equates to an inner join where the join-condition always evaluates to True or where the join-condition is absent from the statement.
Syntax:The basic syntax of CARTESIAN JOIN or CROSS JOIN is as follows:
SELECT table1.column1, table2.column2... FROM table1, table2 [, table3 ]
Read more: SQL - CARTESIAN or CROSS JOINS