Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00811985
Message ID:
00812013
Views:
15
>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