This method returns all relations from the entityName to the root and from the entityName downwards to all the reachable leafs from entityName. All relations to the root are INNER JOIN, all relations from entityName to leafs are LEFT JOIN

RelationCollection GetHierarchyRelations(
	string entityName,
	string objectAlias
)

Function GetHierarchyRelations ( 
	entityName As String,
	objectAlias As String
) As RelationCollection