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_at_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..."
+--------------------------------------------------------------------------+
Received on Wed May 05 1999 - 12:58:48 CDT
