Problem with ADO and duplicate field name (ASP + VBScript)

From: Pat (pistonep_at_hotmail.com)
Date: 07/22/04 

Date: 22 Jul 2004 11:44:46 -0700

Hi all,
first thank god to find such existing newsgroup :). I am a poor
lonesome C++ coder who want to code a personnal ASP project with ADO
and a simple Access Database
I use a basic statement :
"SELECT * FROM OBJECT,SECTION"
and the Table OBJECT and the table SECTION both contains field named :
"Label"
When i try to get field value using :
Response.Write("OBJECT.Label") I get an error :(.. I know that it
comes from the duplicate name but i just can t find an easy way to
solve it (i dont want to use alias cuz it s here just an example, my
table are far much complicated)
Could someone tell me how to do such thing? what the correst ASP . ADO
syntax to retrieve th correct values ?
Thanks in advance
Patrice Pistone