Nested set model: Difference between revisions

Revision as of 20:45, 3 July 2019

Revision as of 09:36, 28 August 2019

Line 110:

WHERE Mid.Left BETWEEN Parent.Left AND Parent.Right

AND Child.Left BETWEEN Mid.Left AND Mid.Right

AND Mid.Node NOT IN (Parent.Node AND, Child.Node)

)

AND Parent.Left = 1 -- Given Parent Node Left Index