I've used the GROUP BY clause thousands of times. Now, all of a sudden in VFP 8.0, I'm getting an error message (Group by clause is missing or invalid) on a simple SQL statement:

SELECT item, vendno, mfgbc ;
FROM icsupl ;
WHERE item = "9999-99-99" ;
GROUP BY 2 ;
INTO CURSOR xxxxx

...will someone tell me what's going on.

Joel