Hierarchy representation [message #373259] |
Fri, 06 April 2001 11:15 |
Salman Mohammed
Messages: 2 Registered: October 2000
|
Junior Member |
|
|
I have 3 tables
Domain, App_group and Application
A domain may have may application groups and
Each application group may have sub app-groups
Each application may have sub applications
Each appliation belongs to an application group
and each application group belongs to a domain
D1 - AG1
**********- AG3
***************- A1
***************- A2
***************- A3
********************- A4
***- AG2
********- A4
********- A6
*************- A7
Domain table has a dom_id
App_group has app_grp_id and super_grp_id and dom_id(FK)
Application has app_id and super_app_id and app_grp_id(fk)
How can I get the tree starting from the domain dom_id
D1
Any info is appreciated.
Sam
|
|
|