| |
|
|
A cross join that does not have a WHERE clause produces the Cartesian product
of the tables involved in the join. The size of a Cartesian product result set
is the number of rows in the first table multiplied by the number of rows in
the second table. The common example is when company wants to combine each
product with a pricing table to analyze each product at each price.
|
|