Since you do not want to list out all the field, you could try:

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

The CustIDs in TempLn.* and BSpotDt.* will still be aliased.

>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?