Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GROUP BY invalid?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
GROUP BY invalid?
Miscellaneous
Thread ID:
00892671
Message ID:
00892671
Views:
56
I thought I was finally getting the hang of the newly rigorous SQL syntax - but I cannot figure out why VFP is complaining about this:
SELECT Category + STR(wmretail,8,2) AS IndexMe, SUM(Shipped) AS Shipped, ;
	SUM(ShippedYTD) AS ShippedYTD, SUM(Return) AS Return, ;
	SUM(ReturnYTD) AS ReturnYTD, SUM(Sold) AS Sold, ;
	SUM(SoldYTD) AS SoldYTD ;
	FROM WalDataFile ;
	GROUP BY Category + STR(wmretail,8,2) ;
	INTO CURSOR PricePtSum
???
TIA
Kogo Michael Hogan

"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?

Ideate Web Site
Next
Reply
Map
View

Click here to load this message in the networking platform