Subject RE: [firebird-support] CTE query works on fb 2.5 but not on fb 3.0
Author Rudi Feijó

Thanks a lot Mark !

>Your problem has nothing to do with CTEs, you are combining implicit

> (SQL-89) joins and explicit (SQL-92) joins, and referencing the
>implicitly joined table from the explicitly joined tables. The rules for
>these have changed in Firebird 3 to be compliant with the SQL
>specification and to avoid hard to diagnose bugs.