SELECT DISTINCT "MBMEMBMASTER"."MEMBER_NO", "MBUCFPRENAME"."PRENAME_DESC", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME", "MBMEMBMASTER"."MEMBGROUP_CODE", "MBUCFMEMBGROUP"."MEMBGROUP_DESC" FROM "MBMEMBMASTER", "MBUCFMEMBGROUP", "MBUCFPRENAME" WHERE ( "MBMEMBMASTER"."MEMBGROUP_CODE" = "MBUCFMEMBGROUP"."MEMBGROUP_CODE" ) and ( "MBMEMBMASTER"."PRENAME_CODE" = "MBUCFPRENAME"."PRENAME_CODE" ) and ( "MBMEMBMASTER"."COOP_ID" = "MBUCFMEMBGROUP"."COOP_ID" ) and ( ( "MBUCFMEMBGROUP"."MEMBGROUP_LEVEL" = 2 ) )