SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 08:19 AM
| ||||
| ||||
 RE: union subqueries in "from" clause (IDS 9.4) your query may work in oracle and sqlserver, for informix try this...... select q, sum(v) from TABLE(MULTISET(select q,v from utest where w='a' union all select q,v from utest where w='b')) group by q; -----Original Message----- From: owner-informix-list@iiug.org [mailto  wner-informix-list@iiug.org]On Behalf Of DanSent: Friday, May 13, 2005 9:35 AM To: informix-list@iiug.org Subject: union subqueries in "from" clause (IDS 9.4) Hi. The SQL Syntax Guide claims that the subject queries are supported. (Ref: http://publib.boulder.ibm.com/infoce...oc/sqls697.htm) E.g. for a simple table like... CREATE TABLE utest ( q INTEGER NOT NULL, w CHAR(1) NOT NULL, v INTEGER NOT NULL, PRIMARY KEY (q,w) ); ....I would expect that the following would work select q, sum(v) from (select q,v from utest where w='a' union all select q,v from utest where w='b') group by q; But instead it produces a "syntax error" pointing to the 2nd "v" (from the left, column 32). Any ideas on why I can't get this to work? sending to informix-list      |
Linear Mode
