At 03:14 PM 1/14/00 +0000, Thomas Lockhart wrote:
>> 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? ;)
Cute! I have no experience trying to read and understand other
people's queries using SQL 92 outer joins so can't really say
whether the "natural" style is more clear than the more cumbersome
explicit notation.
I think both forms are quite readable, though.
- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.