Zusammenfassen aber verschiedene Bedingungen

[mkinzler]

SQL-Code:

Select 
    spie,
    sum(me*pu) AS zalles, 
    SUM( IIF( Sonder = True, me*pu, 0)) as zsonder, 
    SUM( IIF( Verlor = True, me*pu, 0)) as zverlor 
FROM 
    t1 
WHERE 
    spie=spnummer AND fertig=False;