You need to name them with the AS clause:

SELECT TempLn.CustID AS CustID1, <other TempLn fields here>,;
 BSpotDt.CustID AS CustID2, <other BSpotDt fields here>;
 FROM TempLn;
 JOIN BSpotDt ON TempLn.BoIdBase = BSpotDt.BoIdBase;
 WHERE &cSqlCmd2;
 INTO table Results

>I have a custid field in 2 tables.
>
>When I do

>SELECT TempLn.*, BSpotDt.*;
> FROM TempLn;
> JOIN BSpotDt ON TempLn.BoIdBase = BSpotDt.BoIdBase;
> WHERE &cSqlCmd2;
> INTO table Results

>The custid then appears as custid_a and custid_b.
>
>Any way to prevent this from happening?