>In general you've to do grouping and get only key fields plus affreagete columns. After that you join result of that query back to the source table to get the rest.

So, it's like going to flinstone ages again. :( We're loosing a lot of power by conforming to that. If we don't do it, some will say why are you keeping those backward compliant command now instead of using VFP 8 native built in support. If we do, we have to reinvent the wheel again.

Now, it's time to take a decision. Should I conform to that new standard or not? :)