Código SQL [-] TRUNCATE TABLE CAR0006SUM; INSERT INTO CAR0006SUM (ANIO, ID_COLLA, TOTAL_PEN) SELECT ANIO, ID_COLLA, SUM(PENALITZACIO) FROM CAR0006 WHERE PENALITZACIO <> 0 GROUP BY ANIO, ID_COLLA;
TRUNCATE TABLE CAR0006SUM; INSERT INTO CAR0006SUM (ANIO, ID_COLLA, TOTAL_PEN) SELECT ANIO, ID_COLLA, SUM(PENALITZACIO) FROM CAR0006 WHERE PENALITZACIO <> 0 GROUP BY ANIO, ID_COLLA;