What exactly you are trying to query?

If you want find out the employees and whom they are reporting to, you may do the following.

Join Employee to Hierarchy on Territory_type_id

Join another...

You can also left join the second table with the first one (on all the fields) and then select the records that has null values in the second table fields....