select e.area_id,e.area_name,m.area_name
from area e,area m
where e.area_id=m.parent_area_id;






Edit by admin: no contact info permitted on the forum, thank you.