ADO Recordset Source Table Name

I am creating a recordset with an SQL statement that joins two tables. The
two tables have fields with the same name. I have tried the [table] dot
[Field Name] syntax to specify the correct recordset field (like you
can do with Microsoft Access) but ADO does not recognize it. When I ask for
data in one of the like-named fields I get the data from one of the fields
(not the one I want).

Any clue how I specify the source table along with the field name?

Thanks in advance.

[email protected]