| From: | "Ansley, Michael" <Michael(dot)Ansley(at)intec(dot)co(dot)za> |
|---|---|
| To: | "'Thomas Lockhart '" <lockhart(at)alumni(dot)caltech(dot)edu>, "'Don Baccus '" <dhogaza(at)pacifier(dot)com> |
| Cc: | "'Bruce Momjian '" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "'PostgreSQL-development '" <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | RE: [HACKERS] Re: Informix and OUTER join syntax |
| Date: | 2000-01-14 19:27:02 |
| Message-ID: | 1BF7C7482189D211B03F00805F8527F748C445@S-NATH-EXCH2 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)alumni(dot)caltech(dot)edu
South Pasadena, California
************
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ansley, Michael | 2000-01-14 19:38:01 | RE: [HACKERS] [hackers]development suggestion needed |
| Previous Message | Stephen Birch | 2000-01-14 19:20:30 | Re: [HACKERS] Uninstalling PostgreSQL ??!! |