>ED:
> It works after I installed the mdac2.1. I look at the query and found that all the table names are in twice in the from clause:
>SELECT Policies.Subproducer, Policies.First_Name, Policies.Last_Name,;
> Policies.Addr1, Policies.Addr2, Policies.City, Policies.State,;
> Policies.Zip, Policies.Date_Effective, Vehicles.Vehicle_ID,;
> Vehicles.Model_Year, Vehicles.Make, Vehicles.Model;
> FROM Policies Policies, Vehicles Vehicles;
> WHERE Vehicles.Policy_ID = Policies.Policy_ID;
> AND Policies.Last_Name = ?LASTNAME;
> ORDER BY Policies.Date_Effective
>Do you know why?? thanks
It's just explicitly assigning an alias.