Hi,

I have a table with hierarchical 
data.

There is a numeric sortfield where the user sets the sort-order of the children of a particular parent (values from 1 to n für each parent).

How can I write a recursive query which selects the whole tree and honors these sortnumbers.

TIA,

Josef