select mbucfprename.prename_desc , mbmembmaster.memb_name , mbmembmaster.memb_surname , mbmembmaster.member_no, lncontmaster.loancontract_no, lncontmaster.lastpayment_date, lncontmaster.principal_balance from lncontmaster,mbmembmaster,mbucfprename