so wäre es vereinfacht ohne zeit und sprache.
[CODE]
select sum(pos.nAnzahl)as summe, pos.tArtikel_kArtikel, art.cSerie
from dbo.tbestellpos pos
join dbo.tArtikel art
on pos.tArtikel_kArtikel = art.kArtikel
group by pos.tArtikel_kArtikel, art.cSerie
[/CODE]
[CODE]"14" "12143" "White & Cream"
"34,56" "12145" "White & Cream"
"35,64" "12146" "White & Cream"
"10,8" "12147" "White & Cream"
"10,8" "12148" "White & Cream"
"2,16" "12151" "White & Cream"
"14,58" "12155" "White & Cream"
"1" "12205" "White & Cream"
"1" "12211" "White & Cream"
"1" "12212" "White & Cream"
"1" "19889" "White & Cream"
"28,8" "8361" "Wooden"
"210" "8362" "Wooden"
"4,05" "8365" "Wooden"
"26" "8369" "Wooden"
"6,48" "8374" "Wooden"
"80,19" "8375" "Wooden"
"20,16" "8381" "Wooden"
"20" "8389" "Wooden"
"72" "8392" "Wooden"
"18,0000007152557" "8402" "Wooden"
"1" "8725" "Wooden"
"2736,96" "13682" "Woodland"
"709,44" "13683" "Woodland"
"1402,92" "13684" "Woodland"
"75,84" "13685" "Woodland"[/CODE]
die ausgabe sollte dann irgenwie so ausehen
"127,57" "12145" "White & Cream"
"486,68" "8361" "Wooden"
"4925,15" "13683" "Woodland"
