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
--sb--