MySQL Forums
Forum List  »  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 ?
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 ?
3620
December 30, 2004 06:56PM


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.