I was under the impression that if you used NATURAL JOIN, then the join
would be made on the declared keys.
Or doesn't SQL92 support declared keys?
MikeA
-----Original Message-----
From: Thomas Lockhart
To: Don Baccus
Cc: Bruce Momjian; PostgreSQL-development
Sent: 00/01/14 05:14
Subject: Re: [HACKERS] Re: Informix and OUTER join syntax
> 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
************
