1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| With SR_DB1 (REF_ART, STOCKDB1) AS
(
SELECT DB1.REF_ART, SUM(DB1.QTE) as STOCKDB1
FROM DB1.DBO.TARTICLE as DB1, SERVEURLIE.DB2.TARTICLE DB2
GROUP BY DB1.REF_ART
)
, SR_DB2 (REF_ART, STOCKDB2) AS
(
SELECT DB2.REF_ART, SUM(DB2.QTE) as STOCKDB2
FROM SERVEURLIE.DB2.TARTICLE as DB2
GROUP BY DB2.REF_ART
)
, SR_DB (REF_ART, STOCKDB1, STOCKDB2) AS
(
SELECT REF_ART, STOCKDB1, 0 FROM SR_DB1
UNION ALL
SELECT REF_ART, 0, STOCKDB2 FROM SR_DB2
)
SELECT REF_ART, SUM(STOCKDB1) as STOCKDB1, SUM(STOCKDB2) as STOCKDB2
, SUM(STOCKDB1) + SUM(STOCKDB2) as Total
FROM SR_DB
GROUP BY REF_ART; |
Partager