Doug,

The query runs in VFP6 but it doesn't mean that it produces correct result. See Re: Change in SQL commands! Message #941774.

>Why does the GROUP BY statement not function when I include more than one fieldname/columname? For example, this works:
>
>SELECT category FROM test GROUP BY category
>
>But this does not:
>
>SELECT category,id FROM test GROUP BY category
>
>This is only a problem in VFP 8.0. Version 6 works fine.
>
>Thanks