RE: [HACKERS] Re: Informix and OUTER join syntax

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

************