Re: Connect By hierarchy problem

On Oct 17, 10:54 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Mike C" <michaelj..._at_hotmail.com> a écrit dans le message de news: 1161097500.469229.311..._at_m7g2000cwm.googlegroups.com...
> |I have a simple table with a hierarchical structure:
> |
> | CREATE TABLE relation (parent_id number, child_id number);
> |
> | INSERT INTO relation values (10,3);
> | INSERT INTO relation values (3,2);
> | INSERT INTO relation values (2,1);
> | INSERT INTO relation values (10,5);
> | INSERT INTO relation values (14,11);
> | INSERT INTO relation values (11,17);
> |
> | I need to a query to return a results that lists every child and it's
> | direct and not direct parent (it's parents parent and so on), Having
> | the level would be nice too For example, I want this back:
> |
> | Parent_id Child_id
> |
> | 10 3
> | 3 2
> | 10 5
> | 14 11
> | 11 17
> | 10 2
> | 14 17
> | 2 1
> | 3 1
> | 10 1
> |
> | I can't seem to get CONNECT BY to do this.
> |
>
> You seem to not progress since your last question on hierarchical query. :o)
> All what you need is in the previous answers.
> I remind you your post subject if you want to search on Google:
> "Summing hierarchical data SQL"
>
> Regards
> Michel Cadot

I really don't know why you would waste your itme and others posting useless help, There is a lot of information in that other post. If I knew how to do it, I wouldn't waste my time posting here. It is a different problem if you look at it closely, Maybe you shoudl spend your time in chat rooms or something as it seems like you are just killling time. Received on Tue Oct 17 2006 - 11:04:48 CDT