Yes, that's a problem allright. To provide some context, can you explain the motivation for this "UNION"-construct? I recall hearing Informix has problems handling "OR" constructs, is this meant to adress that? Please provide more details.
Rob van Maris Technical Consultant Quantiq xmedia & communication solutions Koninginneweg 11-13 1217 KP Hilversum T +31 (0)356257211 M +31 (0)651444006 E [EMAIL PROTECTED] W http://www.quantiq.com > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Huijser > > That's true. A union query combines several queries' > resultsets to one > resultset. I suppose what we want is that the "group by" will be > performed on the whole resultset and not on parts of the resultset. > > This is what informix can do: > > select ... > from ... > where ... > group by ... > union > select ... > from ... > where ... > group by ... > > And this is what we probably want: > > select ... > from ... > where ... > union > select ... > from ... > where ... > group by ... > > I guess we have a problem, don't we?
