| Subject | Re: [IBO] Problem with Firebird 3 |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2017-03-07T20:32:12Z |
Could it be that IBO expects there to be an alias? Have you tried something like:
select t1.field1, (select t2.field1 from table2 t2 where t2.table1_id = t1.table1_id)
from table1 t1
It's just a guess, I've no clue whether or not it works, most of us have primary keys for our tables (and with a primary key included in the query, I'm pretty certain IBO - provided KeyLinksAutoDefine is true - uses this primary key and not RDB$DB_KEY).
Set