> 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.
>