Xref: alice comp.databases.oracle.server:48334
Path: alice!news-feed.fnsi.net!netnews.com!newsswitch.lcs.mit.edu!newsfeed.mathworks.com!newsfeed1.earthlink.net!nntp.earthlink.net!posted-from-earthlink!not-for-mail
From: Vitaliy Mogilevskiy <vit100gain@earthlink.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: ??Select (Select) from not possible???!!!
Date: Wed, 05 May 1999 10:58:48 -0700
Content-Transfer-Encoding: 7bit
References: <7gprlv$ose$1@news.worldonline.nl>
X-Posted-Path-Was: not-for-mail
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-ELN-Date: 5 May 1999 18:00:54 GMT
X-ELN-Insert-Date: Wed May  5 11:05:03 1999
Organization: EarthLink Network, Inc.
Lines: 29
Mime-Version: 1.0
Message-ID: <373086D8.C04A4500@earthlink.net>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)

It works this way:

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


Good luck!


+--------------------------------------------------------------------------+
| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain@earthlink.net
| Fax :      (707) 516-2163
| Web Page:  http://home.earthlink.net/~vit100gain/index.html
|            *** Free DBA Script Library at my Web Page ***
|
| "Never wrestle a pig - you both get dirty and the pig likes it..."
| "If the only tool you have is a hammer, everything looks like a nail..."
+--------------------------------------------------------------------------+