次に示す例では、階層上での推移的結合を示します。
RETURN SELECT COUNT(1) AS TotalMembers, manager.Org AS Org FROM People manager JOIN People report ON IS_ANCESTOR(manager.Org, report.Org) GROUP BY Org