If I read the changes info correctly it means that if I did need to use the "GROUP BY" feature I would need to group by all the fields. I this examaple I would need to have

GROUP BY piitems.clstkno ,	;
        instock.cdescript ,	;
        piitems.nreqqty ,       ;
        piitems.cuomissu ,	;
        piitems.ddatestamp	;

Is that correct.

Just trying to understand the change.

>Check SET ENGINEBEHAVIOR Command in the help and Re: Change in SQL commands! Message #941774
>Also I would recomend that you check What's New in Visual FoxPro 8.0 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/fooriWhatsNewInVisualFoxPro80.asp?frame=true because it's not covered in VFP9 help.
>
>
>>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