TL;DR: Use a JOIN. I've got a table representing a tree, using two columns: CREATE TABLE "EXAMPLE" ( "PROP_ID&