1 2 3 4 5 6 7 8 9 10 11
| INSERT INTO STOCKS
(STOC_SITE, STOC_PROPRIETAIRE, STOC_EMPLACEMENT, STOC_ARTICLE, STOC_UC1, STOC_UC2, STOC_LOT, STOC_SERIE, stoc_quantite, STOC_ETAT,
STOC_DATE_ENTREE, STOC_DATE_MOUVEMENT, STOC_LIBRE1, STOC_LIBRE2, STOC_LIBRE3)
SELECT MOUV_SITE, MOUV_PROPRIETAIRE, MOUV_EMPLACEMENT, MOUV_ARTICLE, MOUV_UC1, MOUV_UC2, MOUV_LOT, MOUV_SERIE,
SUM(MOUV_QUANTITE) AS Expr2, MOUV_ETAT, MOUV_DATE, MOUV_DATE AS Expr1, MOUV_LIBRE1, MOUV_LIBRE2, MOUV_LIBRE3
FROM MOUVEMENTS
WHERE (MOUV_DATE = '20100128') AND (MOUV_CODE_MOUV = 'PACK') AND ((MOUV_EMPLACEMENT + '|' + MOUV_ARTICLE) NOT IN
(SELECT STOC_EMPLACEMENT + '|' + STOC_ARTICLE AS Expr1
FROM STOCKS))
GROUP BY MOUV_SITE, MOUV_PROPRIETAIRE, MOUV_EMPLACEMENT, MOUV_ARTICLE, MOUV_UC1, MOUV_UC2, MOUV_LOT, MOUV_SERIE, MOUV_ETAT,
MOUV_DATE, MOUV_LIBRE1, MOUV_LIBRE2, MOUV_LIBRE3 |
Partager