The reason that the SQL Query results in VFP produce
Empid_a & Empid_b is that the field exists twice - once in table1 and once in table2. VFP will not allow 2 fields with the same name to co-exist so it is re-naming the fields to be different.
The way to get around this is to input the fields specifically instead of using the '*' (star) operator.
SELECT Field1, ;
Table1.Empid as Empid1, ;
Table2.Empid as Empid2;
<and so on...>