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)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only