Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-00936 select statement in colum list. Is it possible?
You are very hard to understand.
Your second SELECT brings you a column of values from the field B.column_b.
So why do you place it instead of column name? These things are completely
different.
Could you be a bit more specific?
Young Lee <young.lee_at_supplysolution.com> wrote in message
news: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 Tue May 30 2000 - 00:00:00 CDT