??Select (Select) from not possible???!!!

From: Jan Brandsma <j.brandsma_at_bellt-gca.nl>
Date: Wed, 5 May 1999 18:33:13 +0200
Message-ID: <7gprlv$ose$1@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 Wed May 05 1999 - 11:33:13 CDT