|Subject||RE: [firebird-support] CTE query works on fb 2.5 but not on fb 3.0|
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.