Actualizar el campo EXITOT de CAREGART a partir de CAARTALMUBI
De CidesaWiki
(Diferencias entre revisiones)
(New page: UPDATE CAREGART SET EXITOT=(SELECT SUM(A.EXIACT) FROM CAARTALMUBI A WHERE A.CODART=CAREGART.CODART GROUP BY A.CODART) FROM caartalmubi x WHERE CAREGART.CODART=X.CODART) |
|||
| Línea 3: | Línea 3: | ||
WHERE A.CODART=CAREGART.CODART | WHERE A.CODART=CAREGART.CODART | ||
GROUP BY A.CODART) | GROUP BY A.CODART) | ||
| - | FROM | + | FROM CAARTALMUBI X |
WHERE CAREGART.CODART=X.CODART | WHERE CAREGART.CODART=X.CODART | ||
Última versión de 20:04 22 oct 2008
UPDATE CAREGART SET EXITOT=(SELECT SUM(A.EXIACT) FROM CAARTALMUBI A WHERE A.CODART=CAREGART.CODART GROUP BY A.CODART) FROM CAARTALMUBI X WHERE CAREGART.CODART=X.CODART
