What is the meaning of this syntax?

[ReportingAnalyst]

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?

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.

 

[SQLDenis]

that's ORACLE syntax

SQL Server would be


AND P2.emp = @myEmployee;

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[SQLBill]

ReportingAnalyst,

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

-SQLBill

Posting advice: FAQ481-4875

 

[ReportingAnalyst]

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.

 

[ESquared]

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.