>Hi,
>
>I have come across the following problem.
>
>I have the following segment in a SQL Select:
>

>select RF_FILE.RISK_FACT, EQ_FILE*. FROM EQ_FILE JOIN RF_FILE ON RF_FILE.RF_PK = EQ_FILE.RF_PK
>

>
>In SQL Server, because the field RISK_FACT appears before the EQ_FILE*., the column RISK_FACT is selected from the RF_FILE. But when using a VFP database, the SQL Select gets two fields RISK_FACT_A and RISK_FACT_B, one from each table.
>
>So, the SQL Server works as I want it. But with VFP database, it does not work.
>
>Is there a way to change the above SQL Select in VFP so that the column RISK_FACT is selected from the RF_FILE (without added _A or _B)?
>
>TIA

Yesss.
Do not use * in SQL select. Why you allowed to, it's unwise.