RE: Select from (select)

try this: select customer, sum(invoiced_amt) as total_spent from customers group by customer having sum(invoiced_amt) > 1000 Andy ________________________________ From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Phillips, Rob Sent: Thursday, May 06, 2004 11:10 AM To: informix-list@iiug.org Subject: Select from (select) Is it possible to do a select from a select statement in Informix? Ex: Select Customer from (Select Customer, sum(invoiced_amt) astotal_spent from Customers group by Customer) where total_spent > 1000 sending to informix-list