הכפלת רשומות בדוח שיצרתי:

/*
*
‎ * Report ALGO_PURDEMANDSTATUS : ‎רכש‎ ‎לדרישת‎ ‎סטטוסים‎ ‎לוג
*
*/

/* לוג סטטוסים לדרישת רכש */
‎ SELECT SUPPLIERS.SUPNAME AS '‎ספק‎ \'‎מס‎',
‎ SUPPLIERS.SUPDES AS '‎ספק‎ ‎שם‎',
‎ PURDEMANDS.PRDNO AS '‎מרוכזת‎ ‎דרישה‎',
‎ PURDEMANDS.CURDATE AS '‎דרישה‎ ‎תאריך‎',
‎ PURDEMANDS.CONFIRMED AS '‎מאושרת‎',
‎ PURDEMANDS.CLOSED AS 'C ‎סגורה‎',
‎ PURDEMANDS.DETAILS AS '‎פרטים‎',
‎ PURDEMANDSTATS.STATDES AS '‎סטטוס‎ ‎תאור‎',
‎ PORDERS.ORDNAME AS '‎הזמנה‎',
‎ PORDERS.CURDATE AS '‎הזמנה‎ ‎תאריך‎',
‎ PRDITEMS.LINE AS '‎שורה‎',
‎ PART.PARTNAME AS '‎ט‎"‎מק‎',
‎ PART.PARTDES AS '‎מוצר‎ ‎תאור‎',
‎ PURDEMANDSTATUSLOG.UDATE AS '‎דרישה‎ ‎סטטוס‎ ‎תאריך‎',
‎ PORDSTATS.STATDES AS '‎רכש‎ ‎הזמנת‎ ‎סטטוס‎',
‎ PORDSTATUSLOG.UDATE AS '‎הזמנה‎ ‎סטטוס‎ ‎תאריך‎'
FROM PORDERS PORDERS2 , PORDERITEMS , PORDSTATUSLOG , PORDSTATS
, PURDEMANDSTATUSLOG , PART , PRDITEMS , PORDERS , PURDEMANDSTATS
, SUPPLIERS , PURDEMANDS
WHERE (PORDSTATUSLOG.PORDSTAT = PORDSTATS.PORDSTAT)
AND (PORDERS2.ORD = PORDSTATUSLOG.ORD)
AND (PORDERITEMS.ORD = PORDERS2.ORD)
AND (PORDERS.ORD = PORDERITEMS.ORD)
AND (PRDITEMS.PART = PART.PART)
AND (PRDITEMS.ORD = PORDERS.ORD)
AND (PRDITEMS.PURDEMAND = PURDEMANDS.PURDEMAND)
AND (PURDEMANDS.SUP = SUPPLIERS.SUP)
AND (PURDEMANDSTATUSLOG.PURDEMANDSTAT = PURDEMANDSTATS.PURDEMANDSTAT)
AND (PURDEMANDSTATUSLOG.PURDEMAND = PURDEMANDS.PURDEMAND)
‎AND (PORDSTATS.STATDES ='‎נשלחה‎')
‎AND (PURDEMANDSTATS.STATDES ='‎ייצור‎-‎מאושרת‎')
AND ( 1=1 )

;