How do I access the field with the same field name on different tables when doing a join in SQL Server?
Table A contents field status and other fields
Table B also contents field status and other fields
Select A.*, B.* From A join B Where ....
Then how do we access the field status on each table
suppose objRec is the recordset result of the above sql
if I access objRec("status") the result will always be 0
if I access objRec("A.status"), it's giving an error
Please help if you know how!
Thanks in advance
PS: Please email me at LittleTig3r@yahoo.com
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!