Extract parent node from CELKO nested set model

I am using the nested set model (Joe Celko) to represent a binary tree and a procedure similar to the following to extract subordinate nodes.

 SELECT P2.*
   FROM Personnel AS P1, Personnel AS P2   WHERE P1.lft BETWEEN P2.lft AND P2.rgt     AND P2.emp = :myemployee;

I would like to edit this to include each nodes parent node - any ideas ?
Thanks. Received on Wed Jul 17 2002 - 11:57:45 CDT