Support of sql-92 select statement

We've been given the SQL source code for an application written to sql-92 standards. Some of the syntax looks like this: select c_count, count(*) as custdist from ( select c_custkey, count(o_orderkey) from customer left outer join orders on c_custkey = o_custkey and o_comment not like '%express%deposits%' group by c_custkey ) as c_orders (c_custkey, c_count) group by c_count order by custdist desc, c_count desc; Correct me if I'm wrong, but I don't see that IDS 9.x supports this? Fred Prose Arizona Supreme Court

"Fred Prose" <fprose@hotmail.com> wrote in message news:195a4770.0311190822.49fa561b@posting.google.com... > We've been given the SQL source code for an application written to > sql-92 standards. Some of the syntax looks like this: > > select > c_count, > count(*) as custdist > from > ( > select FROM TABLE(MULTISET(SELECT ...)) or something like that. You have to tell Informix that a) a select statement is a bag, and b) you can make a table from it.