Revision as of 08:28, 31 May 2014 edit 46.78.11.180 (talk) Typo ← Previous edit		Revision as of 16:24, 31 August 2014 edit undo 81.187.201.10 (talk) Changed SQL to work in most RDBMS. Next edit →
Line 114: FROM Tree as Child, Tree as Parent WHERE Parent.Left < Child.Left AND Parent.Right > Child.Right -- associate Child Nodes with ancestors GROUP BY Child.Node, Child.Left, Child.Right HAVING max(Parent.Left) = 1 -- Subset for those with the given Parent Node as the nearest ancestor </source>

Nested set model: Difference between revisions