Re: [sqlite] Help on forming the correct aggregation statement with a Union clause

ple Still getting A 1 B 1 D 3 A 1 C 1 D 1 A 1 D 1 D 1 etc. Many thanks Wendy On Thu, May 15, 2014 at 5:56 AM, E.Pasma <pasm...@concepts.nl> wrote: > Op 15 mei 2014, om 12:09 heeft E.Pasma het volgende geschreven: > > > Op 14 mei 2014, om 21:44 heeft Wendy het volge

[sqlite] Help on forming the correct aggregation statement with a Union clause

Hi, Wondering if anyone can help me with the following: - Does anyone know how I can get the SUM() aggregate function within this SQLite statement? SELECT AwayTeam As 'Team', CASE WHEN AwayTeamScore > HomeTeamScore THEN 3 WHEN AwayTeamScore=HomeTeamScore THEN 1 ELSE 0 END AS