Since I could not search for Group By (is there a way to do this) I searched of select group and could not find why the following syntax (which works in VFP 7 does not work in VFP 9.

SELECT						;
	piitems.clstkno ,			;
	instock.cdescript ,			;
	piitems.nreqqty AS nreqqty ,		;
	piitems.cuomissu ,			;
	instock.nqty ,				;
	piitems.ddatestamp			;
	FROM 	piitems , instock		;
	WHERE 	piitems.ddatestamp = issueddate	;
	AND ALLTRIM(UPPER(piitems.clstkno)) = 	;
		ALLTRIM(UPPER(instock.cstkno))	;
	AND piitems.csitecode = gcsitecode	;
	ORDER BY piitems.clstkno  		;
	GROUP BY piitems.clstkno		;
	INTO CURSOR dailyissues

I get an error message that "GROUP BY clause is missing or invalid (error 1807). The help file is not very helpful. I also tried "GROUP BY 1" and get the same error message. What am I missing.

TIA