I am using the nested set model for a hiearchical structure. I am interested in getting the closes children of a selected node.

I only want the boss' immediate subordinates. How would I write this procedure/Query? Use Celko's article for examples (http://www.dbmsmag.com/9603d06.html)

Thanks in advance

Regards
Shai`tan