Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select and Total
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00811985
Message ID:
00812013
Views:
13
>SELECT invnum, name, SUM(qty) AS qty FROM table GROUP BY Invnum+Name INTO cursor cursorname

This give me the folowing error:
"SQL: GROUP BY clause is invalid."

It appears that I can not use more than one field in the group by clause. Is this correct?

Einar
Semper ubi sub ubi.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform