Re: ORA-00936 select statement in colum list. Is it possible?

why not use this:

select column_a, column_b
from A,B
where A.column_a = B.column_b
and column_a = 'test';

HtH
On Wed, 24 May 2000 08:16:28 -0700, Young Lee <young.lee_at_supplysolution.com> wrote:

>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
>
>
>

Gerd Kock
Baltic IT Service GmbH
Gerd.Kock_at_BITS-on-the.net Received on Fri May 26 2000 - 00:00:00 CDT