how get account tree through query from vfp table

From: mfahimaamir@yahoo.com
Keywords: Querier
Remote Name: 203.170.77.254
Remote User:
Date: 10/17/05
Time: 05:47

Comments

i have table with two colum parent number Table create table prune_test (parent number, child number); data Parebt Child Title null 1 null 6 null 7 1 12 1 14 1 15 6 61 6 63 6 65 6 69 7 71 7 74 12 120 12 124 12 127 65 653 71 712 71 713 71 715 74 744 74 746 74 748 712 7122 712 7125 712 7127 748 7481 748 7483 748 7487 Result Requirement in this type Child Title 1 6 61 63 65 653 69 7 71 74 744 746 748 7481 7483 7487 query in oracle select child from prune_test start with parent is null connect by prior child=parent and parent not in (1, 71);

Brought to you by SpaceTime Systems.  All rights reserved.