summation query

Navigation
-1

I'm having a kind of problem with this Query, but what I want to happen is for all values like: Goals Scored , Assists Made , Key passes etc, only once. 

SELECT s.[Statistics ID], s.[Player ID],  s.[Game ID],  s.[Season ID],  s.[Goals Scored], s.[Assists Made],  s.[Key Passes], s.[Successful Tackles],  s.[Successful Interceptions], s.[Goals Conceded], p.[Player Name], p.[Player ID]    
FROM Statistics$ s, Players$ p
WHERE s.[Player ID]=p.[Player ID]

This is what appears in the preview:

    
asked by anonymous 19.01.2015 / 18:55

1 answer

1

To sum uses the SUM (field) and to make the player appear only once use DISTINCT field or can group using GROUP BY field: 

SELECT
  DITINCT p.[Player ID],
  SUM(s.[Goals Scored]) AS gols_jogador,
  SUM(s.[Assists Made]) as assists,
  SUM(s.[Key Passes]) as passes
FROM Players$ p
INNER JOIN Statistics$ s ON s.[Player ID]=p.[Player ID]

I hope that's for sure:)

    
19.01.2015 / 20:29
Error query mongoose keyCode - Javascript