SELECT MBUCFMEMBGROUP.MEMBGROUP_CODE, MBUCFMEMBGROUP.MEMBGROUP_DESC, MBUCFPRENAME.PRENAME_DESC, MBMEMBMASTER.MEMB_NAME, MBMEMBMASTER.MEMB_ENAME, MBMEMBMASTER.MEMBER_STATUS, MBMEMBMASTER.MEMBER_DATE, MBMEMBMASTER.RESIGN_STATUS, MBMEMBMASTER.RESIGN_DATE, MBUCFMEMBTYPE.MEMBTYPE_CODE, MBUCFMEMBTYPE.MEMBTYPE_DESC, MBMEMBMASTER.COOP_ID, MBMEMBMASTER.MEMBER_NO, MBMEMBMASTER.MEMB_SURNAME, MBMEMBMASTER.MEMB_ESURNAME FROM MBMEMBMASTER, MBUCFMEMBGROUP, MBUCFPRENAME, MBUCFMEMBTYPE WHERE ( mbmembmaster.coop_id = mbucfmembgroup.coop_id ) and ( mbmembmaster.coop_id = mbucfmembtype.coop_id ) and ( mbmembmaster.membtype_code = mbucfmembtype.membtype_code ) and ( mbmembmaster.membgroup_code = mbucfmembgroup.membgroup_code ) and ( mbmembmaster.prename_code = mbucfprename.prename_code ) SELECT kpmastreceivedet.coop_id, kpmastreceivedet.kpslip_no, kpmastreceivedet.seq_no, kpucfkeepitemtype.keepitemtype_code, kpucfkeepitemtype.keepitemtype_desc, kpmastreceivedet.shrlontype_code, kpmastreceivedet.loancontract_no, kpmastreceivedet.description, kpmastreceivedet.principal_payment, kpmastreceivedet.interest_payment, kpmastreceivedet.item_payment, kpmastreceivedet.principal_balance, kpmastreceivedet.keepitem_status, keepitem_status as bfkeepitem_status, kpucfkeepitemtype.keepitemtype_grp, kpmastreceivedet.bizzcoop_id, kpmastreceivedet.cancel_id, kpmastreceivedet.cancel_accid FROM kpmastreceivedet, kpucfkeepitemtype WHERE ( kpucfkeepitemtype.coop_id = kpmastreceivedet.coop_id ) and ( kpucfkeepitemtype.keepitemtype_code = kpmastreceivedet.keepitemtype_code )