On 2017-08-17 13:40, Svein Erling Tysvær [email protected] [firebird-support] wrote: > Since the query contains 'from RDB$RELATION_FIELDS R, RDB$FIELDS F > where ... R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME' (SQL-89 type of JOIN) > and not 'from RDB$RELATION_FIELDS R JOIN RDB$FIELDS F ON > R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME' (SQL-92 type of JOIN), I would > be surprised if database access library.
If what? If you mean you "would be surprised if it would be a database library", why? For example Jaybird still has some SQL-89 style joins in its database metadata, even though I dislike SQL-89 style joins. There are simply more important things to tackle, and in some case keeping the SQL-89 style join means I don't have to consider if I need to add a where clause (or an AND) or not when generating the where condition, which keeps things simpler. Mark
