Skip navigation links

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 ?


Advanced Search

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.
For example:

SELECT Company_Defaults.CompanyID, Company.CompanyID
FROM Company_Defaults Left Join Company on Company_Defaults.CompanyID =
Company.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.

TIA

Charles

Options: ReplyQuote


Subject Views Written By Posted
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 ? 2318 Charles Swartz 12/30/2004 06:56PM
Re: 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 ? 1681 Paul Auen 01/05/2005 10:51AM


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.