I have a DB in SQLite3 and I'm trying to figure out a recurrent query to get all ancestor elements from a many-to-many hierarchy. I can find lots of examples of traveling down the hierarchy, but no examples of going up. I don't need the whole path, just the top level element.
The table is organized like this: parentID | name | childID | level
Thanks!
Aucun commentaire:
Enregistrer un commentaire