Luis Carlos Junges wrote:

>
> Do you have a maximum level if 3 ? if so, you could just make left joins
>
>> with the same table
>>
>
> No. The maximum level has no limit.
>

I think you will need CTE (Common Table Expression) I had don't used it
yet, so could not give you the sample code.

You will need FB 2.1 for it.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br