... in dem Du eine Case-Anweisung verwendest etwa so:
BirgittaCode:Select Kunde, Sum(Case When Monat = 1 Then PlanWert Else 0 End) PlanJan, Sum(Case When Monat = 1 THen IstWert Else 0 End) IstJan, Sum(Case When Monat = 2 Then PlanWert Else 0 End) PlanFeb, Sum(Case When Monat = 2 Then IstWert Else 0 End) IstFeb, ... From YourTable Where ... Group By Kunde;
Bookmarks