I have inheritedthe an application written in VFP5 that I am migrating to VFP9.

There is a very complex view that in VFP9 complains that the group by is missing or invalid.

In the VFP5 view, there is no group by clause. I understand basically what the error means, etc. but...

In the past, to convert the SQL, I often created more than one query and combined them to get the same result.

The issue I have this time is, this is a complex view and it is updateable. Any ideas on how to do it in one, keeping it as a single updateable view?

i.e. how to add the necessary group by clause that would return the same result?

TIA,
Mike