Re: does oracle support natural joins

I doubt this would be on an exam :). I just wanted to know if any verson of oracle supports the natural join syntax;  select x,y from tableA natural join tableB If tableA and tableB share a column with named z it would be joined on that column. Sybase supports this and it would make my persistence layer so much easier to write, however other db's do not support this (db2) ; And I need to run on many DB's . I may have been incorrect about this being part of the sql 92 standard , does anybody know ?

In article <828lvj$7qo$1_at_autumn.news.rcn.net>,   "Alan Shein" <alanshein_at_erols.com> wrote:
> This sounds like a question on a final exam. If not, what do you
_really_
> need to know (from a business rules point of view), or in other words
what
> prompted the question? It's not a usual thing to ask.
>
> <bubbashrimp_at_my-deja.com> wrote in message
> news:826ml6$s4r$1_at_nnrp1.deja.com...
> > does oracle support natural joins per sql 92 standard ? If so which
> > versions ? Thanx!
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 06 1999 - 09:23:01 CST