SELECT "MBMEMBMASTER"."COOP_ID", "MBMEMBMASTER"."MEMBER_NO", "MBMEMBMASTER"."PRENAME_CODE", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME", "MBMEMBMASTER"."MEMBGROUP_CODE", "MBMEMBMASTER"."SALARY_AMOUNT", "MBMEMBMASTER"."MEMBER_TYPE", "MBMEMBMASTER"."INCOMEETC_AMT", "SHSHAREMASTER"."PERIODBASE_AMT", "SHSHAREMASTER"."PERIODSHARE_AMT", "SHSHARETYPE"."UNITSHARE_VALUE", "MBUCFPRENAME"."PRENAME_DESC", "MBUCFMEMBGROUP"."MEMBGROUP_DESC" , shsharemaster.sharetype_code FROM "MBMEMBMASTER", "SHSHAREMASTER", "MBUCFMEMBGROUP", "MBUCFPRENAME", "SHSHARETYPE" WHERE ( "MBMEMBMASTER"."COOP_ID" = "SHSHAREMASTER"."COOP_ID" ) and ( "MBMEMBMASTER"."COOP_ID" = "MBUCFMEMBGROUP"."COOP_ID" ) and ( "MBMEMBMASTER"."MEMBER_NO" = "SHSHAREMASTER"."MEMBER_NO" ) and ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and ( "MBMEMBMASTER"."MEMBGROUP_CODE" = "MBUCFMEMBGROUP"."MEMBGROUP_CODE" ) and ( "SHSHAREMASTER"."COOP_ID" = "SHSHARETYPE"."COOP_ID" ) and ( "SHSHAREMASTER"."SHARETYPE_CODE" = "SHSHARETYPE"."SHARETYPE_CODE" )