Is it possible to use a nested select in the from clause of a select statement in Informix? Below is an example of what we are trying to do:

select sum(col1) from
(Select col1, col2 from table1)

Jeremy

select sum(col1) from table (multiset(Select col1, col2 from table1))

That is exactly what we needed. Thanks for the quick response.

Jeremy