Ohne "save data"
[ ruban.de ] [ Antworten ] [ Forum ]
Geschrieben von Paul Jauck on September 23, 2003 um 14:46:
Ist eine Lösung ohne "save data" möglich ? wie ?
SELECT M.BEAK2, M.ARTNR, M.VAN, M.BZEK, M.BEKA1!!M.BEKA2
, M.PREBWDM, SUM(MENGE), 0, SUM(MENGE+((MENGE/100)*20))
, 0, 'EVG SAN'
FROM T150B.MATGI M, T150B.KONSOLL K
WHERE M.ARTNR = K.ARTNR
AND ( M.beak2 BETWEEN 'BA' AND 'BD' )
AND (M.ARTNR BETWEEN '6505' AND '6510' )
AND M.MATK BETWEEN 'A' AND 'H'
AND K.SKE = 'E'
AND K.BVK IN ('8D','81')
GROUP BY
M.BEAK2, M.ARTNR, M.VAN, M.BZEK, M.BEKA1, M.BEKA2
, M.PREBWDM
UNION ALL
SELECT M.BEAK2, M.ARTNR, M.VAN, M.BZEK, M.BEKA1!!M.BEKA2
, M.PREBWDM, 0, SUM(MENGE), SUM(MENGE+((MENGE/100)*20))
, 0, 'EVG SAN'
FROM T150B.MATGI M, T150B.KONSOLL K
WHERE M.ARTNR = K.ARTNR
AND ( M.beak2 BETWEEN 'BA' AND 'BD' )
AND (M.ARTNR BETWEEN '6505' AND '6510' )
AND M.MATK BETWEEN 'A' AND 'H'
AND K.SKE = 'A'
AND K.BVK IN ('50','52')
GROUP BY
M.BEAK2, M.ARTNR, M.VAN, M.BZEK, M.BEKA1, M.BEKA2
, M.PREBWDM
UNION ALL
SELECT M.BEAK2, M.ARTNR, M.VAN, M.BZEK, M.BEKA1!!M.BEKA2
, M.PREBWDM, 0 , 0 , 0
, SUM(VALUE (MENGE, 0)), 'EVG SAN'
FROM T150B.MATGI M, T150B.KONBESTAND K
WHERE M.ARTNR = K.ARTNR
AND ( M.beak2 BETWEEN 'BA' AND 'BD' )
AND (M.ARTNR BETWEEN '6505' AND '6510' )
AND M.MATK BETWEEN 'A' AND 'H'
AND K.ZK IN ('A','N', 'L', 'D')
AND K.BVK IN ('8D','81','50','52','5R')
GROUP BY
M.BEAK2, M.ARTNR, M.VAN, M.BZEK, M.BEKA1, M.BEKA2
, M.PREBWDM
sa data as T00129 SELECT BEAK2, ARTNR, VAN, BZEK, COL1, PREBWDM
, SUM(COL2), SUM(COL3), SUM(COL4)
, SUM (COL5), SUM(COL5) - SUM(COL4)
, (SUM(COL5) - SUM(COL4))*PREBWDM, COL6
FROM T00129
GROUP BY BEAK2, ARTNR, VAN, BZEK, COL1, PREBWDM, COL6
HAVING (SUM(COL5) - SUM(COL4)) > 0
Schreibe eine Antwort
|