> And if I understand SQL92 correctly, if tab1, tab2, and tab3 only
> share col1 in common, then you can further simplify:
> SELECT *
> FROM tab1 NATURAL RIGHT JOIN (tab2 NATURAL RIGHT JOIN tab3)
> Is that right? ...and some
> might argue this is less clear than explicitly listing the column(s)
> to join on.
But this is "natural", right? ;)
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California