|Subject||Fw: [IBO] please help with multi query lookup on same table.|
> What version of Firebird/InterBase are you using?
> This behavior is different depending on which database and version.
> ----- 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.
>> i am using Ibo 4.8.7 with delphi 2007.
>> have problem with this query below:
>> , 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
>> why not
>> how to fix this?
>> thanks all.