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

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 Sun May 09 1999 - 23:01:19 CDT