>
> This:
>
> SELECT *
> FROM table1, table2
>
> Is an outer join. Every row in table1 will be returned with every
> row of table2, so if both tables have 10 rows, the record set will
> have 100.
That is called a Cartesian Product.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
