select lncontmaster.coop_id, lncontmaster.loancontract_no, lncontmaster.member_no, lncontmaster.loantype_code, lncontmaster.loanapprove_amt, lncontmaster.startcont_date, lncontmaster.principal_balance, lncontmaster.int_continttype, lncontmaster.int_contintrate, lncontmaster.int_continttabcode, lncontmaster.int_contintincrease, lncontmaster.int_intsteptype, mbucfprename.prename_desc, mbmembmaster.memb_name, mbmembmaster.memb_surname, mbmembmaster.membgroup_code, mbucfmembgroup.membgroup_desc, lnloantype.loantype_desc, lncontmaster.loanpayment_type, lncontmaster.period_payment from lncontmaster, mbmembmaster, mbucfprename, mbucfmembgroup, lnloantype where ( lncontmaster.member_no = mbmembmaster.member_no ) and ( mbucfprename.prename_code = mbmembmaster.prename_code ) and ( mbucfmembgroup.membgroup_code = mbmembmaster.membgroup_code ) and ( lncontmaster.loantype_code = lnloantype.loantype_code ) select lncontstatement.coop_id, lncontstatement.loancontract_no, lncontstatement.seq_no, lncontstatement.loanitemtype_code, lnucfloanitemtype.sign_flag, lncontstatement.slip_date, lncontstatement.operate_date, lncontstatement.ref_docno, lncontstatement.period, lncontstatement.principal_payment, lncontstatement.interest_payment, lncontstatement.principal_balance, lncontstatement.prncalint_amt, lncontstatement.calint_from, lncontstatement.calint_to, lncontstatement.bfintarrear_amt, lncontstatement.interest_period, lncontstatement.item_status from lncontstatement, lnucfloanitemtype where ( lncontstatement.loanitemtype_code = lnucfloanitemtype.loanitemtype_code )