Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GROUP BY invalid?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
GROUP BY invalid?
Divers
Thread ID:
00892671
Message ID:
00892671
Vues:
55
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform