Re: Subquery Question

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Wed, 07 Apr 1999 15:21:22 -0700
Message-ID: <370BDA62.7598F7BF@earthlink.net>

Yes you can:

select A.column

,           B.column
from     table                     A
            (select    column
             from      table)      B

+--------------------------------------------------------------------------+

| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain_at_earthlink.net
| Web Page:  http://home.earthlink.net/~vit100gain/index.html

|            *** Free DBA Script Library at my Web Page ***

+--------------------------------------------------------------------------+

Paul Bennett wrote:

> In some SQL flavors I can do something like
>
> SELECT cola, colb, (Select cola from tablea where tablea.colb =
> tablec.cola) from tablec;
>
> basically I can use a select that returns one value as a column.
>
> I can not do this in Oracle 8. What is the workaround?
>
> Thanks.
>
> -- Paul

-- Received on Wed Apr 07 1999 - 17:21:22 CDT