Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ** Select (Select ) not possible !!??
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:31:22 CDT