how to traverse the tree in both direction
5562Apr 29 2005 — edited Apr 29 2005Hi there,
I have data like the following
parent child
1
1 2
1 3
2 4
3 5
6
6 7
6 8
I want to get the following result by giving the criteria child = 3
1/2
1/2/4
1/3
1/3/5
They are the rows related to record 3.
Could you tell me how to do this?
Thanks,
Mandy