Now of course the numbers would be allot more random than that, but I have a table of id's that show a parent/child relationship. I am trying to construct a query where I input a id, say 22, and it will return a sequential list of all items that would be related, so in this example it would return:
As 21 is a child of 22, 20 is a child of 21, etc ..
Imagine kinda like a pyramid. Seems there should be an easy solution, I just can't picture it. :-\