It's known bechavior of VFP SQL Select. If there are more than one field with the same name in Select list than VFP will add some suffix to make them unique because you cannot have two fields with the same name in the cursor/table. Use field1 AS field2fromtable1 clause to resolve it.