Actually the group by is required for the query I'm doing. The select statement I posted is a simplified version of the one I'm actually using.
I did run the query without the "group by" and the results were still wrong. I believe this is a VFP bug, I'm going to call Microsoft this AM.