SQL Error (-294) : The column (tot_mes) must be in the GROUP BY list.

--0-2008861098-1116361047=:64929 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi all, I need your help, I have two servers with Windows2000 A.S., one on informix 9.30 and another with 9.21. My Query : Select codcta, a.tpomov, sum(a.impmn1) Total, max(coddiv) coddiv, min('04') nromes, min('2004') periodo, (Select sum(cb_dmov.impmn1) from cb_dmov where cb_dmov.codcia = '2' and cb_dmov.coddiv like '00002' and cb_dmov.periodo = '2004' and cb_dmov.nromes <= '04' and cb_dmov.codcta = a.codcta and cb_dmov.tpomov = a.tpomov ) as Tot_Mes