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

You can try using inline sql where a select statement lies in the from clause. Depends on what results you want.

e.g

    select name, address
    from (select name from table1, table 2........),

             addresses
    where.......

 Mark

Jan Brandsma wrote in message <7gprjh$omn$1_at_news.worldonline.nl>...
>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 Thu May 06 1999 - 07:28:56 CDT