Subject Re: Efficiently find records from a self join without children records or a field=1
Author Bhavbhuti Nathwani
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 ?