SQL Recursive Join

Question

I have a Table called "Level" which has a column, "idParent" that makes a self reference.

What I want to do is to retrieve a tuple with the entire hierarchy.. Something like this:

enter image description here

zmbq · Accepted Answer · 2013-07-30 18:14:11Z

1

Recursive and hierarchical queries are not standard. Some databases support them, some don't, and the support varies.

See the link above for a backgrounder.

answered Jul 30, 2013 at 18:14

zmbq

39.1k15 gold badges109 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

I got @zbmq, thanks for your support. That wasn't what I was looking for, but may help at some point.

You can probably try and pivot the result of a recursive query and get what you wanted.