Subject Re: Res: [firebird-support] Recursive SQL statement Help
Author Alexandre Benson Smith
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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil