Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by clause error in sql with NO group by clause
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00801354
Message ID:
00801372
Views:
20
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
Map
View

Click here to load this message in the networking platform