-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Sajidnet2
Message 1 in Discussion
This is a treeview
Root
-- Cricket1
---Cricket2
---sachin
--Cricket3
--dravid
--FootBALL1
--pele
I have a table like this
Id type name
100 Root Root
101 cricket Cricket1
102 cricket Cricket2
103 player sachin
104 cricket Cricket3
105 player dravid
106 football FootBALL1
107 player pele
To maintain the parent-child relationship i have the following relation table
id ParentId
100 null
101 100
102 101
103 102
104 100
105 104
106 100
107 106
I need to query the db and the get the following result
Root
-- Cricket1
---Cricket2
--Cricket3
--FootBALL1
--pele
means when ever it encounters the type of cricket it should not get the childs inside
it(as in Cricket3) however if it encounters a child of type cricket , it should go
ahead and get the child (as in Cricket1)
Its oracle db , so start with connect by clause can be used
Thanks in Advance
sajid
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
