Hi,

Please show how exactly resultset should be because i now do not understand your needs. Query return path and return in order a before b what more?

Regards,

Hi,

thank you for your ideas.

But I think your solution would only work if the anchor query would select treemembers of level 1.

Whereas my query starts with "where Green = 'Yes'" and these elements are in different levels.

I have read that this should be possible with "window functions", but I can't find an example which works for me.

Regards,
Josef