SELECT LINE.cCode, SUM(ROLLS.nWeight_Roll) AS nAccepted ;
FROM LINE ;
LEFT JOIN ROLLS ;
ON LINE.ID=ROLLS.clineid AND UPPER(ALLTRIM(CSTATUS))=="ACCEPTED" ;
GROUP BY LINE.cCode ;
INTO CURSOR tmpProduction