>Don't forget that VFP8 will not allow queries like this. Everything that is not an aggregate field (SUM(), TOP(), etc.) that is in the SELECT clause must be included in the GROUP BY clause. It looks like your other solution is what Michel really needs since he needs the whole record that has the minumum value in a particular field.

Does it mean that someone who has such a field definition in a SQL will run into an error in VFP 8?