Re: ** Select (Select ) not possible !!??

Jan,

You can define a function to take the place of your nested select. Obviously it is different to your code in the other DBMS's, however it doesn't leave you with a huge JOIN clause. We use this to include the descriptions of codes in our select statements, rather like an OO operation.

HTH, David.

Sanjaya Ganesh wrote:

> HI Jan,
>
> Yes! I guess Oracle 8i supports your requirement, but unfortunately not earlier versions. Sorry to say that you might have to go for a join if you are on < Oracle 8i.
>
> Sanjay.
>
> "Jan Brandsma" <j.brandsma_at_bellt-gca.nl> wrote:
> >Hi everyone,>
> >Oracle is new to me, but I was very disappointed that the following query
> >doesn't work!
> >
> >Select Name, (Select Name from Table2 where Table2.Table2ID=Table1.Table2ID)
> >from Table1;
> >
> >I am aware of the fact that tis simple query can be solved with joins but
> >that means that I have to change code which works fine on Informix, SQL
> >Server and Access. Beside that it is also possible to use aggregate
> >functions in this manner.
> >
> >Hopefully I missed something and is this possible after all!
> >
> >Any help is highly appriciated!!
> >
> >Jan Brandsma
> >
> >
> >
Received on Mon May 10 1999 - 21:22:44 CDT