In VFP 9 there is a command SET ENGINEBEHAVIOR 70 that causes the VFP9 sql parser to ignore the ASNI standard and allow VFP version 7.0 and earlier syntax to run with out throwing errors. EB is the abbreviation for SET ENGINEBEHAVIOR


>Hi Tore,
>
>Thanks for the info. I actually just add the COMNAM_08 as GROUP BY. I am not sure what EB means. Please explain. Thanks!
>
>I have this now and I am getting the right data.
>
>

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

>
>Best Regards,
>Sam