>What is wrong with this SELECT statement? I am getting "SQL: GROUP BY clause missing or invalid" error message. Please help... Thanks, Sam
>
>

>SELECT VENID_55, COMNAM_08, SUM(COST_55*TNXQTY_55) AS STDCOST, ;
>	SUM(ORDCST_55*TNXQTY_55) AS POCOST ;
>FROM VRSUMINV1 ;
>GROUP BY VENID_55 ;
>ORDER BY VENID_55 ;
>INTO CURSOR VRSUMINV2
>

In VFP9 a SELECT that has a GROUP BY all fields in the field list must be either aggregate functions or part of the group by clause. Your statement has the field COMNAM_08 listed which is neither an aggregate nor part of the group by.