>VFP will group all the records togther using the GROUP BY clause and select the value(s) not specified in the clause from the last record that is physically in the table. This can and does lead to numerous problems because some developers don't realize this.
That's good to know to some degree. Of course, since the behavior isn't docuemnted (at least I couldn't find anything) it could change with the next release or service pack.
-Mike