nested query for "pat2" table
mysql> select t.appln_id, t.filing_date, t.appln_kind, t.people, GROUP_CONCAT(pu.publn_kind) from (select a.appln_id, a.filing_date, a.appln_kind, GROUP_CONCAT(p.pers_name) as people from appln as a left join pers_appln as pa on a.appln_id= pa.appln_id left join person as p on pa.pers_id= p.pers_id group by a.appln_id) as t left join publn as pu on t.appln_id= pu.appln_id group by t.appln_id;
just for test!