Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is the meaning of this syntax?

Status
Not open for further replies.
Oct 11, 2006
300
US
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?

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.
 
ReportingAnalyst,

Are you using ORACLE? If so, then you've been posting in the wrong forum.

-SQLBill

Posting advice: FAQ481-4875
 
Hi,

I am using SQL Server 2000. I am using Joe Celko's example of nested set model. I am trying to implement his example for hierarchical structures. So his example must be based on Oracle.

Thanks.
 
Joe Celko is a big arrogant something-or-other.

There, I had to get it out. He has some good ideas, but he does stupid stuff too and because of his ego he does it on a colossal scale. I've talked to him in person, and he was personable enough, but unrepentant about anything. That guy lives on offending people.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top