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