> >
> > Jun,
> >
> > Thanks for the post, the code worked with your example but I can not get it to work with my data. I have about 30 fields in this table, do I need to cast them all
> >
> > Select TOQtemp
> > Goto Top
> > Select field1, field2, field4, field5, field6,P_ID,;
> > Cast(Sum(field4) As N(12,2)) As item1,;
> > CAST(Sum(field5) As N(12,2)) As item2,;
> > CAST(Sum(field6) As N(12,2)) As Total;
> > FROM TOQtemp Group By P_ID, field2
> > Browse
> >
> > This is the code I am trying to execute but still get the SQL Group error.
> >
> > Ryan J. Lashway
> > http://www.lashtech.com
>
> No you dont need to CAST() anything. The Standard SQL rule, incorporated in VFP9, says that for a
> SELECT columnlist GROUP BY columnlist
> the two column lists must include all the same columns (eccept for the aggregation function columns, i e the SUM(), COUNT(), MIN(), MAX(), or AVG() group aggegations.
> Just so the one knows exactly what the sum applies to.
> Take
>

 custid, amount, city 
>    123   10      London
>    123   20      Paris
>    123    5      New York 

>

SELECT custid, city, SUM(amount) FROM table GROUP BY custid

> It's easy to see that the sum for custid 123 should be 35 but which city is correct?
>
> -Anders

Same error, changed code to look like


Ryan J. Lashway
http://www.lashtech.com