number of errors=3
number of warnings=0
Group=chkGrpHierarchy
select parentid,childid,geoname_hierarchy.creationtime,geoname_hierarchy.createdbyuserid,type,ansiname,featurecode from geoname_hierarchy left join geoname on geonameid=parentid where not exists (select 1 from geoname where geonameid=childid)
parentid childid creationtime createdbyuserid type ansiname featurecode 8282105 8281924 2014-06-09 17:16:49.330379 null null As Surm al A`la PPL 8282105 8281926 2014-06-09 17:16:49.330379 null null As Surm al A`la PPL 8282102 8282101 2014-06-09 17:16:49.330379 null null Hayd al Wusaya PPL