[osxman]

Joe Celko's Trees and Hierarchies in SQL for Smarties (book) is a good start for better understanding/defining trees. http://a.co/9eVzvji

[petepete]

There's a very useful chapter in Karwin's SQL Antipatterns on this topic too.