[HTML]In my table three field is there:-EmpId,EmpName,M ngr_Id.Now I want to show the Employee name on node in TreeView(ASP.NE T).In Root node only those employee who is not having any manager after that in second level only those employee who are under manager but they have subordinate and after that in third level of child node respective subordinate should be there.I am not able to write query for second level employee who is having subordinate.Tha t query should display only there subordinate[/HTML]