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 ?

[Charles Swartz]

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