A situation in which a query includes two or more tables that are not linked by a join. If executed, this type of query retrieves all possible combinations between each table and may lead to inaccurate results.
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.
Cartesan product is the result of a query when the two tables are not joined by any type of join. All the possible combinations of one table are displayed with the other table just like a cartesan product in algebra
