More important than standards compliant, the new way returns unambiguous results.

Personally, I don't give a hang about standards but I DO want queries that return the right results. ;-)

>The reason for the change is that just using a single column can cause incorrect results. The new way is standards compliant.
>
>>Yikes! I am moving a vfp7.0 app to 9.0, it use sum and group by in a lot of routines. Do you have to group by on all the columns ?