Using INNER JOIN, referencing fields with same name in diff tables
Posted on 2001-06-29
I have the following SQL Statement
SELECT * FROM tblClaims INNER JOIN tblUsers ON tblClaims.fldUserID = tblUsers.fldUserID INNER JOIN tblProducts ON tblClaims.fldProductID = tblProducts.fldProductID WHERE tblClaims.fldVerified = 0
It works fine, I put it into a recordset. How do I then access fields from the different tables?
Rs("Points") - for example. What if there is a UserID in two of the tables that comes up with different values on any 1 recordset?
Ive tried Rs("tblblah.points") - but it doesn't work. How can I do this?