Patrick Aljord schrieb:
Hey all,
I have comments(id,content) and votes(comment_id,vote). vote is a tinyint.
I would like to select total votes for each comment, I tried:
"select content, sum(v.votes) from comments c left join votes v on
c.id=v.comment_id"
but it only returns first result obviously, any idea how I could do this?
did you tried in your mysql console?
please add the output here
and add GROUP BY - this is required by SQL standard
SELECT
comments.content,
SUM(votes.votes)
FROM
comments
LEFT JOIN
votes
ON
comments.id = votes.comment_id
GROUP BY
comments.id
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]