>In addition to Michel's observation, use field names in GROUP BY clause, not numbers.

Are you saying this as a matter of Best Practice, or because it absolutley does not work in Sql Server?

I just want to understand the context of your suggestion.


On a related matter, I seem to recal a situation in VFP where you *have* to use numbers in either the Order or Group clause. Perhaps it was when doing a Union. I don't recall all the details.

.