SELECT MBMEMBMASTER.MEMBER_NO, MBUCFPRENAME.PRENAME_DESC, MBMEMBMASTER.MEMB_NAME, MBMEMBMASTER.MEMB_SURNAME, MBMEMBMASTER.MEMBGROUP_CODE, MBMEMBMASTER.RESIGN_DATE, SHSHAREMASTER.SHARETYPE_CODE, SHSHAREMASTER.SHARESTK_AMT, SHSHAREMASTER.SHAREMASTER_STATUS, SHSHARETYPE.UNITSHARE_VALUE, 0 as operate_flag FROM MBMEMBMASTER, SHSHAREMASTER, MBUCFPRENAME, SHSHARETYPE, MBREQRESIGN WHERE ( SHSHAREMASTER.MEMBER_NO = MBMEMBMASTER.MEMBER_NO ) and ( MBMEMBMASTER.PRENAME_CODE = MBUCFPRENAME.PRENAME_CODE ) and ( SHSHAREMASTER.SHARETYPE_CODE = SHSHARETYPE.SHARETYPE_CODE ) and ( MBMEMBMASTER.COOP_ID = SHSHAREMASTER.COOP_ID ) and ( SHSHAREMASTER.COOP_ID = SHSHARETYPE.COOP_ID )