I have a hierarchy table with the hierarchy (Schools under different owners). I have another hierarchy table (Departments under different schools) both has diff path. But how to relate both the table to get the Different departments under diff schools and diff owners. how to relate both the tables.....