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