geoname hierarchy, child must exist

number of errors=2
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	
6324533	6476875	null	null	null	Santa Ponsa	PPL	
6355014	6478203	null	null	null	Cala San Vicente	PPL