i have a database table that stores folder information. In this table there is a folder_parent field that relate this table with itself. I would like to test if a folder is descendant of another folder, my problem is that i don't know tha maximun dept of relations, I don't know if is possibile to do this with just a query or i may need a recursive store procedure.
What do you think? thank you.
