>The usual approach to that one is either to SET ENGINEBEHAVIOR TO (??? some older VFP version), or to mention all fields, either in the GROUP BY clause, or with something like MAX().

This also what I would like to avoid.

>I don't know an easy alternative, therefore, I recommend the GROUP BY option.

I believe I have seen a SQL syntax with a sub query that could give me that.