SELECT SUM(p.Runs + p.Wickets + p.Catches + p.Runouts) AS points, u.UserId FROM tblPlayerUser AS pu INNER JOIN tblUser AS u ON pu.UserId = u.UserId INNER JOIN tblPlayer AS p ON pu.PlayerId = p.PlayerId GROUP BY u.UserId
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)