how to show user name instead of user id from another table

Question

Hi I am saving the master records Like say for example i am saving Fruits names into the database , my table is having columns ( fruitId,Name,AddBy(this field is saving using Session("UserID"))

 

My User Table is a separate table where i have userID as well as its user name , Now on Fruit listing view i am showing fruit ID,Name,Add BY ( instead of UserID i want to show user name against this user Id from User Table how to achieve that )