Re: Grouping

Posted in 2003

Mark D. Stock — Thu, 28 Aug 2003 16:37:34 +0100 — source: Usenet: comp.databases.informix

SRam wrote: > I always get an error " virtual column must have explicit name" > > I wrote a query to execute and store result in another table..I query does > sum operation on fields with related keys.... A little more information would help people answer, but in essence you must give your virtual column (SUM) an explicit name. Try something like: SELECT SUM(my_col1) AS my_col1_sum FROM my_table WHERE ... Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list