Subject | IBO 4.7B16 , Firebird 2 and inner join query |
---|---|
Author | Marcin Bury |
Post date | 2007-04-02T13:28:48Z |
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
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