ReportingAnalyst
MIS
Hi,
I am trying to get a list of subordinates from a nested table model. What is the meaning of the bold part in the SQL query below?
Thanks.
I am trying to get a list of subordinates from a nested table model. What is the meaning of the bold part in the SQL query below?
Code:
SELECT P2.*
FROM Personnel AS P1, Personnel AS P2
WHERE P1.lft BETWEEN P2.lft AND P3.rgt
AND P2.emp = [b]:myEmployee;[/b]
Thanks.