Subject IBO 4.7B16 , Firebird 2 and inner join query
Author Marcin Bury
Hello All

I have following query:

SELECT H_O.H_ORDER_ID
, H_O.H_ORDER_TYPE
, H_O.CUSTOMER_ID
, H_O.ORDERED_DATE
, H_O.CONTAINER_ID
, H_O.SURVEYOR_ID
, H_O.REL_ID
, CONT.CONTAINER_NO
, CONT.SHIPOWNER_ID
, CONT.SUPPLIER_ID
FROM H_ORDERS H_O
INNER JOIN CONTAINERS CONT ON H_O.CONTAINER_ID = CONT.CONTAINER_ID AND
CONT.C_STATUS IN (0,1)

IBO returns column names from CONTAINERS table as i.e.
CONTAINERS.CONTAINER_NO instead of CONT.CONTAINER_NO,
then when searching IBO coplains that column CONTAINERS.CONTAINER_NO is
unknown (this is logical with FB 2)

Is it IBO or something with my query?


TIA
Marcin