MySQL Forums :: Microsoft Access :: How do you get MySQL to return the table names in the resultset when more than one table is in the select statement using ADO ?
How do you get MySQL to return the table names in the resultset when more than one table is in the select statement using ADO ?
Posted by: Charles Swartz
Date: December 30, 2004 06:56PM
This should be a <duh> but I can't find the answer.
SELECT Company_Defaults.CompanyID, Company.CompanyID
FROM Company_Defaults Left Join Company on Company_Defaults.CompanyID =
Where Company.CompanyID = 1
And Company_Defaults.CompanyID = 1
This is over-simplified but it will give you the symptom.
With Access, Microsoft SQL Server, Sybase and Oracle, the resultset will
return the fields as Company.CompanyID and Company_Defaults.CompanyID.
With MySQL both fields are returned as just CompanyID. How do I get MySQL to
include the table names for identically named fields ?
I'm converting a huge program written in VB 6 using ADO and this problem is a show stopper.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.