select MBUCFPRENAME.PRENAME_DESC,MBMEMBMASTER.MEMB_NAME,MBMEMBMASTER.MEMB_SURNAME, MBMEMBMASTER.MEMBGROUP_CODE, slslippayin.* from slslippayin,MBMEMBMASTER,MBUCFPRENAME WHERE MBMEMBMASTER.PRENAME_CODE = MBUCFPRENAME.PRENAME_CODE and slslippayin.MEMBER_NO = MBMEMBMASTER.MEMBER_NO and MBMEMBMASTER.COOP_ID = slslippayin.MEMCOOP_ID select * from slslippayin left join slslippayindet on slslippayin.payinslip_no = slslippayindet.payinslip_no