How do i select/query all the tree from parent to the last node includeing all levels within the one table which have parent and child fields
e.g
C_Key Parent Order Description 1 1 M1 2 1 1 M1S1 3 2 1 M1S1O1 4 2 2 M1S1O2 5 1 2 M1S2 6 5 1 M1S2O1 7 5 2 M1S2O2 8 2 M2 9 8 1 M2S1 10 9 1 M2S1O1 11 9 2 M2S1O2 12 8 2 M2S2 13 12 1 M2S1O1 14 12 2 M2S1O2
Now if I want to select the first set through the SQL up to the as much as i want down level.... but i am unable to write the query to select the sepecific set of values from top to botom or parent to last chiled node.... any help will be highly appriciated
Regards