SELECT mbucfprename.prename_desc,mbmembmaster.memb_name,mbmembmaster.memb_surname, LNREQTRNLNRESPONSDET.COOP_ID, LNREQTRNLNRESPONSDET.TRNLNREQ_DOCNO, LNREQTRNLNRESPONSDET.SEQ_NO, LNREQTRNLNRESPONSDET.OPERATE_FLAG, LNREQTRNLNRESPONSDET.TRN_MEMCOOPID, LNREQTRNLNRESPONSDET.TRN_MEMNO, LNREQTRNLNRESPONSDET.TRN_CONCOOPID, LNREQTRNLNRESPONSDET.TRN_CONTRACTNO, LNREQTRNLNRESPONSDET.TRNPRNBAL_AMT, LNREQTRNLNRESPONSDET.TRNINTARREAR_AMT, LNREQTRNLNRESPONSDET.TRNLASTCALINT_DATE, LNREQTRNLNRESPONSDET.PERIODPAYPRN_AMT, LNREQTRNLNRESPONSDET.PERIODPAYINTARR_AMT, LNREQTRNLNRESPONSDET.BFPRNBAL_AMT, LNREQTRNLNRESPONSDET.BFINTARREAR_AMT FROM LNREQTRNLNRESPONSDET, MBMEMBMASTER, MBUCFPRENAME WHERE ( LNREQTRNLNRESPONSDET.TRN_MEMCOOPID = MBMEMBMASTER.COOP_ID ) and ( LNREQTRNLNRESPONSDET.TRN_MEMNO = MBMEMBMASTER.MEMBER_NO ) and ( MBMEMBMASTER.PRENAME_CODE = MBUCFPRENAME.PRENAME_CODE ) SELECT LNREQTRNLNRESPONS.COOP_ID, LNREQTRNLNRESPONS.TRNLNREQ_DOCNO, LNREQTRNLNRESPONS.TRNLNREQ_CODE, LNREQTRNLNRESPONS.TRNLNREQ_DATE, LNREQTRNLNRESPONS.CONCOOP_ID, LNREQTRNLNRESPONS.LOANCONTRACT_NO, LNREQTRNLNRESPONS.MEMCOOP_ID, LNREQTRNLNRESPONS.MEMBER_NO, LNREQTRNLNRESPONS.TRNLN_PRNAMT, LNREQTRNLNRESPONS.TRNLN_INTAMT, LNREQTRNLNRESPONS.BFPERIOD_PAYMENT, LNREQTRNLNRESPONS.BFLAST_PERIODPAY, LNREQTRNLNRESPONS.BFPRNBAL_AMT, LNREQTRNLNRESPONS.BFINTARREAR_AMT, LNREQTRNLNRESPONS.BFLASTCALINT_DATE, LNREQTRNLNRESPONS.TRNLNREQ_STATUS, LNREQTRNLNRESPONS.ENTRY_ID, LNREQTRNLNRESPONS.ENTRY_DATE, LNREQTRNLNRESPONS.ENTRY_BYCOOPID, LNCONTMASTER.LOANTYPE_CODE, LNLOANTYPE.LOANTYPE_DESC, mbucfprename.prename_desc,mbmembmaster.memb_name,mbmembmaster.memb_surname, LNCONTMASTER.PERIOD_PAYAMT FROM LNREQTRNLNRESPONS, LNCONTMASTER, MBMEMBMASTER, MBUCFPRENAME, LNLOANTYPE WHERE ( LNREQTRNLNRESPONS.CONCOOP_ID = LNCONTMASTER.COOP_ID ) and ( LNREQTRNLNRESPONS.LOANCONTRACT_NO = LNCONTMASTER.LOANCONTRACT_NO ) and ( LNREQTRNLNRESPONS.MEMCOOP_ID = MBMEMBMASTER.COOP_ID ) and ( LNREQTRNLNRESPONS.MEMBER_NO = MBMEMBMASTER.MEMBER_NO ) and ( MBMEMBMASTER.PRENAME_CODE = MBUCFPRENAME.PRENAME_CODE ) and ( LNCONTMASTER.COOP_ID = LNLOANTYPE.COOP_ID ) and ( LNCONTMASTER.LOANTYPE_CODE = LNLOANTYPE.LOANTYPE_CODE )