Re: column as select ?

From: Chris <chris_at_nospam.com>
Date: Fri, 21 Dec 2001 19:42:12 -0000
Message-ID: <ndMU7.23$M3.154@news-srv1.fmr.com>

Hi ,

Select t1.col1, t1.col2, ... , your_columns_name from TABLE1 t1, (Select blabla from TABLE2 where ....... ) your_columns_name where ..... order by .....

Regards,
Chris

"Isma" <Ismael_at_NOSPAMiballo.com> wrote in message news:9vt73b$kso$1_at_sunnews.cern.ch...
> Hi,
> 1/ I want to know if a column in TABLE1 can be the result of a select
blaba
> from TABLE2 if this query returns one result ...
> 2 / Is this possible to add this column in a predetermined place in TABLE1
> in ORACLE ?
>
> Thanks ..
>
>
Received on Fri Dec 21 2001 - 13:42:12 CST