Re: Help with Cartesian product

BackAt-Ya wrote:

> What's a Cartesian product

Joining tables without a join criteriia. In a two table cartersian join, row one of table 1 is joined with every single row in table 2. Ditto for every other row in table 1.

> and why or why wouldn't I want to use one?

It creates massive result sets.

Sometimes you need to use a cartersian join. Most often you do not and a cartesian join is a result of slipper fingers.

> Please give me some examples.

SELECT
  *
FROM table1,

     table2;

--
Billy