>You could also add posname to the view, which works with VFP sql but breaks ANSI Sql (all fields must be in the group by except summation fields).

It works, in the sense that it won't err, but it does not pick the posname value from the right record. When it does it is a coincidence.