Cartesian Join
A Cartesian Join is also called Cartesian Product or Cross Join. In this each record in the first table is matched with each record in the second table. These type of Join is useful while performing certain statistical analysis. The result of Cartesian Join will have m*n rows. The figures below illustrates the use of Cartesian join with examples.
A Cartesian join will get you a Cartesian product. A Cartesian join is when you join every row of one table to every row of another table. You can also get one by joining every row of a table to every row of itself. To make your own Cartesian join all you really need is to take your basic select with two or more tables and remove the where clause. In general a cartesian join is very resource intensive, and it's usually done by accident.
Selecting the data from multiple tables and accidentally omitting a proper join also produces a Cartesian product, which is an incorrect result. Most cartesian products are produced in error.