Thursday, September 25, 2008

Cartesian product

Simply, it is a join without a Where clause. It gives you every row in the
first table, joined with every row in the second table.

SELECT * FROM AntiqueOwners, Orders;