Traversing Trees in SQL
If you need to read up on techniques for traversing tree structures in SQL, Joe Celko is your man (as ever). Here are his three articles about constructing, traversing and manipulating hierarchical trees in SQL.
Permalink: http://blog.iandavis.com/2000/01/traversing-trees-in-sql/
Other posts tagged as
programming