>
> 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.
Actually, that's a cross join, or Cartesian product. I'm not sure if cross
joins fall within the category of outer joins. Left and right joins are both
outer joins, but a cross join is equivalent to the union of left and right
outer joins.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
