-
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]
-
what does your sql statement look like?