Hi Erik

Please search in this group for my messages during the past couple of months to which Svein has kindly responded with solutions.

Hope it helps.

Kind regards.

--- In firebird-support@yahoogroups.com, "Erik De Laet" <erik.delaet@...> wrote:
> But another question: does anyone has a query or stored proc which will list all childs (not only the immediate ones but all of them) of a given parent in a self referencing table with Id and PId ?