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