I've a table as given below
Expand|Select|Wrap|Line Numbers
- ID LChild RChild
- 1 2 3
- 2 4 6
- 3 5 7
- 4 8 9
- 5 10 11
- 6 12 13
- 7 0 14
Now i've to find out the LChild of 1, 1 has 2 in it's left 3 in it's right and 2 has 4,6 as it's child and 4 and 6 has also two-two child each......At final 1 has 7 child on it's left and on it's Right it's 6
i want to Count Left and right node and level for MLM application
And also i've find out for each ID i.e 1,2,3,4,5,6,7