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.