select mbucfprename.prename_desc, mbmembmaster.memb_name, mbmembmaster.memb_surname, mbmembmaster.membgroup_code, lnreqloan.coop_id, lnreqloan.loanrequest_docno, lnreqloan.member_no, lnreqloan.loantype_code, lnreqloan.loanrequest_amt, lnreqloan.loanrequest_status, lnreqloan.loancontract_no, lnloantype.prefix, lnloantype.document_code from mbmembmaster, mbucfprename, lnreqloan, lnloantype where ( mbmembmaster.prename_code = mbucfprename.prename_code ) and ( lnreqloan.member_no = mbmembmaster.member_no ) and ( mbmembmaster.coop_id = lnreqloan.memcoop_id ) and ( lnreqloan.loantype_code = lnloantype.loantype_code )