I use now the JoinLinks, but it doesn't change anything. the SQL-Statement is
now:
select
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

and the JoinLinks are:
A.FMFDID=FD.FDID
A.FMMPID=11
B.FMFDID=FD.FDID
B.FMMPID=12
C.FMFDID=FD.FDID
C.FMMPID=13

What have I forgotten ?

Guido.