| Hierarchical Data [message #374346] |
Wed, 06 June 2001 14:55 |
myles
Messages: 4
Registered: June 2001
|
Junior Member |
|
|
If I have a table designed to represent a hierarchy (tree) how can I get the data out? Is connect by my only option?
GROUP_ID | PARENT_GROUP_ID | GROUP_TYPE_ID
1 NULL 1
2 1 2
3 1 2
4 2 3
5 4 3
6 4 4
In the example table above suppose I have a GROUP_ID and I want to select the tree leading to (above) that node. That is the parent, grandparent and so forth. I also need to join to the GROUP_TYPE table to resolve the GROUP_TYPE_ID
I know this can be partially achieved with connect by, but since I want to join to other tables at the same time, it won't work.
Thanks for any help
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
