Versuch's mal so:

Code:
select artikelnr,sum(menge) SUMME_TOT,
     Sum(Case When Kennz = 'A' Then Menge Else 0 End) "Davon A",
     Sum(Case When Kennz = 'B' then Menge Else 0 End) "Davon B",
     Sum(Case When Kennz = 'C' then Menge Else 0 End) "Davon C" 
from File 
where Datum between x and y 
group by artikelnr 
order by SUMME_TOT desc, artikelnr
Birgitta