SELECT DISTINCT SUM(SUB_FABRIC_DELIVERED.QUANTITY) qty, FABRIC_DELIVERED.FDNO, 
SUB_FABRIC_DELIVERED.COLOR,
SUB_PROGRAM.COLOR, 
SUB_PROGRAM.REQ_KGS,
FABRIC_DELIVERED.PPNO
FROM SUB_FABRIC_DELIVERED,
     FABRIC_DELIVERED,
     PROGRAM, 
     SUB_PROGRAM
WHERE ((SUB_FABRIC_DELIVERED.FDNO = FABRIC_DELIVERED.FDNO)
 AND (SUB_PROGRAM.JOBNO = PROGRAM.JOBNO)
 AND (FABRIC_DELIVERED.PPNO = PROGRAM.PPNO))
GROUP BY FABRIC_DELIVERED.FDNO, 
         FABRIC_DELIVERED.PPNO, 
         FABRIC_DELIVERED.SUBPP, 
         SUB_FABRIC_DELIVERED.COLOR, 
         PROGRAM.PPNO, PROGRAM.SUBPP, 
         SUB_PROGRAM.COLOR,
         SUB_PROGRAM.REQ_KGS
ORDER BY SUB_FABRIC_DELIVERED.COLOR 

SELECT   SUM (s.quantity) qty, f.fdno, s.color, sp.color, sp.req_kgs, f.ppno
    FROM sub_fabric_delivered s, fabric_delivered f, program p,
         sub_program sp
   WHERE s.fdno = f.fdno
     AND sp.jobno = p.jobno
     AND f.ppno = p.ppno
GROUP BY f.fdno, s.color, sp.color, sp.req_kgs, f.ppno
ORDER BY s.color;