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.c om...
> 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.

XPS is supporting this syntax.

Andreas

Fred Prose wrote:
> 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