My SQL Tutorials - Cartesian Joins
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. Here is an example of a SELECT statement with a Cartesian JOIN included...