Guys,
Check out Joe Celko's two chapters on tree structures in the 2nd edition of "SQL for Smarties". It's pretty comprehensive.
-- -Josh Berkus Aglio Database Solutions San Francisco