Hi, > Hi, > > > Is this list allowed to post SQL queries ou links? Anyway if someone is > interested and can help me, I did a recent post on SO which has been a > great challenge to me, although it seems simple at first sight: > > > https://stackoverflow.com/questions/56220744/recursive-relationship-on-dictionary-table
If your question is, if Firebird supports recursive queries via Common Table Expressions (CTE), then the answer is yes. Since Firebird 2.1. https://firebirdsql.org/refdocs/langrefupd21-select.html#langrefupd21-select-cte -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.