Table pcKeyword kwId | keyword

Table proPhrase kwId | vote

Table contraPhrase kwId | vote

So the vote column is an integer and i want to sum it for the specified keyword Something like this:

exampleKeyword | 12 | 47

Til now i have this but i doesnt work correctly:

    SELECT pcKeyword.kwId, pcKeyword.keyword, SUM( proPhrase.vote ) AS proVotes, SUM( contraPhrase.vote ) AS contraVotes
FROM pcKeyword
INNER JOIN proPhrase ON proPhrase.kwId = pcKeyword.kwId
INNER JOIN contraPhrase ON contraPhrase.kwId = proPhrase.kwId
GROUP BY pcKeyword.keyword ORDER BY pcKeyword.keyword ASC