Subject RE: [firebird-support] Recursive SQL statement Help
Author Sasha Matijasic
> >
> 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.

If you use 2.1 try CTEs, otherwise you can write a recursive stored procedure.