Say I have a table like
ID ParentID Name
1 0 Test1
2 1 Test2
3 2 Test3
4 3 Test4
5 4 Test5
6 2 Test6
7 0 Test7
8 7 Test8
i know the ID of a parent whose ID is 1 and it has some direct & indirect child. now how could i remove all direct & indirect child in chain if i know the parent ID?
please guide me with sql.
Thanks
i know the