Can anybody please tell me what the difference is between Hierarchy and HierarchyBelongsTo functions please?
When would you use one over the other?
Have a look at
Unbalanced, n-level hierarchies
and to the referenced tech doc:
Both variants of HierarchyXXXX LOAD prefix are explained in these documents, including samples.
Retrieving data ...