| Child to Parent [message #374568] |
Tue, 19 June 2001 05:32 |
C.S.VENKATA SUBRAMANIAN
Messages: 2
Registered: June 2001
|
Junior Member |
|
|
I have a table where I store all the details of the dealers.
The structure of the table is as follows
Dealer_code
Dealer_name
circle_code
dealer_type
parent_dealer
I have both child and parent records stored in the same table.
I want to trace the parent is dealer and the parent of the parent. It is easy to do the other way to find all the children of the given parent.
Can any one tell me the way out or how can this be achieved.
TIA
Venkat
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
