Select from (select)
This is a multi-part message in MIME format.
------_=_NextPart_001_01C43384.9C3B5D61
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Is it possible to do a select from a select statement in Informix?
Ex:
Select Customer from (Select Customer, sum(invoiced_amt) as total_spent
from Customers group by Customer) where total_spent > 1000
------_=_NextPart_001_01C43384.9C3B5D61
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.6944.0">
<TITLE>Select from (select)</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=3D2 FACE=3D"Arial">Is it possible to do a select from a =
select statement in Informix?</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Ex:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Select Customer from (Select Customer, =
sum(invoiced_amt) as total_spent from Customers group by Customer) where =
total_spent > 1000</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C43384.9C3B5D61--
sending to informix-list
"Phillips, Rob" <RPhillips@ce-a.com> wrote in message
news:c7dpno$a7v$1@terabinaries.xmission.com...
>
> Is it possible to do a select from a select statement in Informix?
>
select x from table(multiset(select x from my_table)) as mt