Hi, The first table has two fields:
* from_user , db.auth_user* * to_user , db.auth_user* both are referencing db.auth_user. How to get the list of records in the first table with the corresponding first_name of the two fields? I am confused, because I don't know how to differentiate the two field --- db.auth_user.name for the two fields. Regards, Ashraf --
