Level 0 0
Level 1 1 9
Level 2 3 5 2 3 8
Level 3 6 7 2
Level 4 10

Now hope you can understand the above tree
0 is parent of 1 and 9
1 is parent of 3 , 5 and 2
5 is parent of 6, and 7
7 is parent of 10

9 is parent of 3 and 8
8 is parent of 2

All is present in the same table with parent id and child id table
ID Parent id child id qty

1 0 1 10
2 1 3 5
3 1 5 121
4 1 2 12
5 5 6 14
6 5 7 67

So Now i need to write a query in access can you please tell me the query as i cnanot use connect by clause in access which i can use in oracle.
We need to access access only as it is available for an application purpose,