adding a column

[beefsack]

ok, say i had a db which had a playerID field and a score field. say the playerID isnt a primary key and there is multiple instances of it. if i did "SELECT score FROM table WHERE playerID=4" it might return multiple results. how would i get a total of score instead of multiple results? i hope that made sense :P

[Redcircle]

SELECT sum(score) FROM table WHERE playerID=4

[beefsack]

thanks a ton thats perfect