General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
hi
i've a table structure (recursive) like this
Seq --descr ----------pseq ---lvl
1-----Master -------- 0 ------0
2-----customer------- 1 ------1
3-----supplier------- 1 ------1
4-----Customer List-- 2 ------2
5-----Supp. List----- 3 ------2
now i want the desired result like this
Seq --descr ----------pseq ---lvl
1-----Master -------- 0 ------0
2-----customer------- 1 ------1
4-----Customer List-- 2 ------2
3-----supplier------- 1 ------1
5-----Supp. List----- 3 ------2
means that the Parent then list of child and if any child has further child then it should come right under it and so on for all the record. the heirarchy should be in a sequence of parent --> child --> child .... and so on
Thanks in advance
Anwar
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only