I don't understand what that has to do with grouping. I tried it anyway, though and got the same error, here's what I changed the sql to read...
SELECT SUM(aTmpData.nBegin), ;
SUM(aTmpData.NADDS),;
SUM(aTmpData.nNew) , ;
(aTmpData.nRein0 + ;
aTmpData.nRein30 + ;
aTmpData.nrein90 + ;
aTmpData.nrein91 + ;
aTmpData.nrein181), ;
SUM(aTmpData.nRein0), ;
SUM(aTmpData.nRein30), ;
SUM(aTmpData.nrein90), ;
SUM(aTmpData.nrein91), ;
SUM(aTmpData.nrein181), ;
SUM(aTmpData.nterms), ;
SUM(aTmpData.nLOE), ;
SUM(aTmpData.nRiteShare), ;
SUM(aTmpData.nOther), ;
SUM(aTmpData.nEnd), ;
SUM(aTmpData.nSwitchout) ;
FROM aTmpData ;
WHERE aTmpData.cSite = junk.cSite ;
AND aTmpData.ddate = aDatelist(i2-1,1) ;
group by (aTmpData.nRein0 + ;
aTmpData.nRein30 + ;
aTmpData.nrein90 + ;
aTmpData.nrein91 + ;
aTmpData.nrein181) ;
INTO TABLE dkstep1
then, just in case that was wrong.... i tried
SELECT SUM(aTmpData.nBegin), ;
SUM(aTmpData.NADDS),;
SUM(aTmpData.nNew) , ;
(aTmpData.nRein0 + ;
aTmpData.nRein30 + ;
aTmpData.nrein90 + ;
aTmpData.nrein91 + ;
aTmpData.nrein181) as total, ;
SUM(aTmpData.nRein0), ;
SUM(aTmpData.nRein30), ;
SUM(aTmpData.nrein90), ;
SUM(aTmpData.nrein91), ;
SUM(aTmpData.nrein181), ;
SUM(aTmpData.nterms), ;
SUM(aTmpData.nLOE), ;
SUM(aTmpData.nRiteShare), ;
SUM(aTmpData.nOther), ;
SUM(aTmpData.nEnd), ;
SUM(aTmpData.nSwitchout) ;
FROM aTmpData ;
WHERE aTmpData.cSite = junk.cSite ;
AND aTmpData.ddate = aDatelist(i2-1,1) ;
group by total;
INTO TABLE dkstep1
both gave me the same error...
I don't understand 1) why I need a group clause or 2) how should it read if I do need one?
(Not trying to sound difficult, I really just don't understand why one would be required)
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement