Please send me a DDL to create the database so I can take a closer look at
this issue.

Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com]On Behalf Of Marcin Bury
> Sent: Monday, April 02, 2007 6:29 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] IBO 4.7B16 , Firebird 2 and inner join query
>
>
> 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