Subject Re: [IBO] IB_Query phenomenom
Author guido.klapperich@t-online.de
> Repeating, if you use explicit JOINs, you won't need JoinLinks, so consider
> that when building up your MyQuery string...
>

Perhaps you can help me. I failed to built the query with explicit JOINs. Do you
know how to do it ? This is the query:

FD.FDID,FD.FDDCID,FD.FDDFID,FD.FDBONUS,
A.FMID,A.FMFDID,A.FMMPID,(select MPNAME from MAINPRODUCTGROUPS where
MPID=A.FMMPID) as MPNAME,A.FMDISCOUNT,A.FMDISCOUNTNEW
,
B.FMID,B.FMFDID,B.FMMPID,(select MPNAME from MAINPRODUCTGROUPS where
MPID=B.FMMPID) as MPNAME,B.FMDISCOUNT,B.FMDISCOUNTNEW
,
C.FMID,C.FMFDID,C.FMMPID,(select MPNAME from MAINPRODUCTGROUPS where
MPID=C.FMMPID) as MPNAME,C.FMDISCOUNT,C.FMDISCOUNTNEW
from
FOLLOWUPDISCOUNTS FD,
FOLLOWUPDISCOUNTS_MP A
,
FOLLOWUPDISCOUNTS_MP B
,
FOLLOWUPDISCOUNTS_MP C
where
A.FMFDID=FD.FDID
and A.FMMPID=11
and
B.FMFDID=FD.FDID
and B.FMMPID=12
and
C.FMFDID=FD.FDID
and C.FMMPID=13