Hello Experts,
I have a two-column table defined, as follows, for representing the tree structure :
CREATE TABLE PARENT_CHILD (
ID VARCHAR(5) NOT NULL PRIMARY KEY
PID VARCHAR(5) FOREIGN KEY REFERNCES PARENT_CHILD
)
Is it possible with a single standard SQL query, without any proprietary features, to retrieve all the children and all its descendants down the lineage ?
Start Free Trial
