Linq Joins

(from tran in opidb.transactions
                             join ben in opidb.beneficiaries
                             on tran.tran_ben_id equals ben.ben_id
                             where tran.tran_status == "Pending" && 
                             tran.tran_iscustapproved == "Approved"
                             join users in opidb.user_info
                             on tran.tran_user_id equals users.user_id
                             select new SuperModel() { ben = ben, tran = tran, user = users }).ToList();