Re: Nested sort, trying again

>> but I believe that the *direct* children of a given node can be found with the following query: <<

To convert a nested sets model into an adjacency list model:

SELECT B.emp AS boss, E.emp
  FROM OrgChart AS E

       LEFT OUTER JOIN
       OrgChart AS B
       ON B.lft
          = (SELECT MAX(lft)
               FROM OrgChart AS S
              WHERE E.lft > S.lft
                AND E.lft < S.rgt);