Hierarchical query
Redirect to:
Hierarchical and recursive queries in SQL