Re: SQL -- SELECT Recursive

[Peter Brawley]

> The "intra-table recursive" table manages
> and describes the relation ship via data.

Graphs, yes.

> Is I read it, CTE works for a table that contain
> the tree pointer. That's not the case I presented

Your ...

tblStructure
parent_id (tblOrganization.id)
child_id (tblOrganization.id
relationship

... defines an edge table. How do you think such a graph being cyclic or a network or a parts explosion prevent CTE use? A few examples ...

https://stackoverflow.com/questions/23633138/cte-for-parent-child-relation-with-multiple-parent

https://stackoverflow.com/questions/30233716/sql-recursive-cte-where-used-bom-explosion

https://stackoverflow.com/questions/56849394/sql-detect-cycle-in-directed-graph

https://www.k2.com/blog/efficient-directed-cyclic-graph-traversal-in-sql

https://stackoverflow.com/questions/62785161/use-cte-instead-of-table-variable-for-recursive-function