sql statement help

[VinothRao]

hi, i have the following table. Parent ID.......ID.......Name NULL..........10001.....Region1 NULL..........10002.....Region2 NULL..........10003.....Region3 10001.........501.......Test1 10001.........502.......Test2 10002.........503.......Test3 10002.........504.......Test4 10003.........505.......Test5 10003.........506.......Test6 501...........507.......Test7 501...........508.......Test8 502...........509.......Test9 502...........510.......Test10 Actually im doing a Treeview control in my ASP.NET application. I can see the Parent Name, and its child popping out, BUT how to see the ID (501, 502) is having child in ParentID?? My SQL in ASP.NET is "SELECT ID, ParentID, Name FROM Test" In order to show Child in the Parent, the ParentID has to be NULL. Any idea??

[Robin_Roy]

You can get a clue from a simple SQL query like Select distinct ID, ParentID, Name from dbo.tblTest where ID In (Select ParentID from dbo.tblTest) The output would be like ID ParentID Name ----------- ----------- ------------- 501 10001 Test1 502 10001 Test2 10001 NULL Region1 10002 NULL Region2 10003 NULL Region3