select c.code code, c.name name from rpt_region_2005_ business professional c where regionid in (select regionid from rpt_region_2005_ professional business where areacode in (select code from rpt_region_2005 where HIERACHYCODE like 'root00001%' and regiontype = 1) and regionid in (select regionid from rpt_rcmember where collectionid = 111)) and c.regionid in (select a.regionid from (select regionid from rpt_region_2005_ professional business where regionid in (select regionid from rpt_region_2005_ professional business where areacode in (select code from rpt_region_2005 where HIERACHYCODE like 'root00001%' and regiontype = 1) and regionid in (select regionid from rpt_rcmember where collectionid = 111))) a left join (select a.regionid from rpt_rpt_2005_sm a where a.reportFlag = '1' and a.reportTemplateID = 1802 and a.year = 2005 and a.specialityCode = 'business professional' and a.month = 1 and a.regionid in (select regionid from rpt_region_2005_ professional business where areacode in (select code from rpt_region_2005 where HIERACHYCODE like 'root00001%' And regionType = 1) And regionID in (SELECT REGI Onid from rpt_rcmember where collectionid = 111))) B on a.regionid = B.Regionid WHERE B.REGION IS NULL) Order by C.code
