Add this missing GROUP BY statement
Code:SELECT tblscorerel.scoreid, tblscores.id, sum( tblscores.score ) FROM tblscorerel INNER JOIN tblscores ON tblscorerel.scoreid = tblscores.id Group by tblscorerel.scoreid, tblscores.id ORDER BY sum( tblscores.score )




Reply With Quote