Re: Support of sql-92 select statement

Posted in 2003

Andreas Weininger — Thu, 27 Nov 2003 18:50:30 +0100 — source: Usenet: comp.databases.informix

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