sql sum using one to many relations

Question

i have two tables

comments
------------------
id       text

rates
---------------------
id    comment_id    score

My query is ... but sum operation not affected. just one row will be returen.

SELECT *, SUM(rates.score) FROM comment LEFT JOIN rate ON (rate.comment_id = comment.id)

Answer 1

SELECT comment.*, SUM(rates.score) FROM comment LEFT JOIN rate ON (rate.comment_id = comment.id)
GROUP BY comment.id