What version of Firebird/InterBase are you using?
This behavior is different depending on which database and version.

Thanks,
Jason

----- Original Message -----
From: "send2iwan" <send2us@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, July 09, 2009 2:25 AM
Subject: [IBO] please help with multi query lookup on same table.


> hi,
>
> i am using Ibo 4.8.7 with delphi 2007.
>
> have problem with this query below:
> SELECT
> A.CUSTID
> , B.NAME
> , C.NAME
> , D.NAME
> FROM CUSTOMER A
> LEFT OUTER JOIN MARKETING B
> ON A.IMP=B.MKTG
> LEFT OUTER JOIN MARKETING C
> ON A.EXP=C.MKTG
> LEFT OUTER JOIN MARKETING D
> ON A.OUT=D.MKTG
>
> Result in field properties always like this
> A.CUSTID
> B.NAME
> B.NAME
> B.NAME
>
> why not
> A.CUSTID
> B.NAME
> C.NAME
> D.NAME
>
> how to fix this?
>
> thanks all.