Take a look at my answer to:
"SQL*Plus: Select in select"
in comp.databases.oracle.tools
the 05-18-2000.
--
Regards
Michel
Young Lee <young.lee_at_supplysolution.com> a écrit dans le message :
392BF24C.F83984F1_at_supplysolution.com...
> I am trying to use a select statement in column list and got ORA-00936
> error.
> Is there any way around it?
>
> For example,
> select column_a, (select column_b from B where A.column_a=B.column_b)
> from A where column_a = 'test';
>
> Thanks,
> Young Lee
>
>
>
Received on Thu May 25 2000 - 00:00:00 CDT
