select orgid,orgname,orgparent,level,l.levelname from organization o start with orgparent is null connect by prior orgid=orgparent left join orglevels l on l.levelid=level