hi, i have some table's on my database that is like this:
this fatherid contains the id of one registry on database, and so on, so i have like a tree one registry connected to others by this fatherid, but here is the deal, i need to delete one registry that has some others connected to this one that i need to delete. example:
here is the deal, i need to delete the house01 and all other registry that are inside, the problem is the house097 has no direct connection to the house01 because the fatherid of it is connected with house098.
how can i accomplish this task, delete the house01 and all other registrys on the tree that are connected with it?