title: SUM() based on a different condition to the SELECT
body: <p>Hi is there a way that I can do the SUM(total_points) based on a different condition to the rest of the SELECT statement, so I want the SUM(total_points) for every row which is &lt;= to $chosentrack? but the rest of the conditions of the SELECT statement to be what they are below. I need them to all be returned together..as I am populating a league table.</p>
  
  <p>Thanks a lot for any help.</p>
  
  <pre><code>SELECT
      members.member_id,
      members.teamname,
      SUM(total_points) as total_points,
      total_points as last_race_points 
  FROM
      members,
      members_leagues,
      member_results 
  WHERE
      members.member_id = members_leagues.member_id 
      AND members_leagues.league_id = '$chosenleague' 
      AND member_results.track_id = '$chosentrack' 
      AND members_leagues.start_race = '$chosentrack' 
      AND member_results.member_id = members_leagues.member_id
  GROUP BY
      members.member_id 
  ORDER BY
      member_results.total_points DESC,
      last_race_points DESC, 
      members.teamname DESC
  </code></pre>