Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GROUP BY: missing clause
Message
From
21/12/2006 16:28:29
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
GROUP BY: missing clause
Miscellaneous
Thread ID:
01179682
Message ID:
01179682
Views:
61
What is wrong with this SELECT statement? I am getting "SQL: GROUP BY clause missing or invalid" error message. Please help... Thanks, Sam
SELECT VENID_55, COMNAM_08, SUM(COST_55*TNXQTY_55) AS STDCOST, ;
	SUM(ORDCST_55*TNXQTY_55) AS POCOST ;
FROM VRSUMINV1 ;
GROUP BY VENID_55 ;
ORDER BY VENID_55 ;
INTO CURSOR VRSUMINV2
Next
Reply
Map
View

Click here to load this message in the networking platform