Name the fields:
select RF_FILE.RISK_FACT AS RF_FILE_RISK
,.... -- (always use exact list of the necessary fields. I doubt that you need ALL fields from the table
FROM ...
>/pre>
>Hi,
>
>I have come across the following problem.
>
>I have the following segment in a SQL Select:
><pre>
>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.