I need to show the records like this, but I am not sure how to put in the SUM into this. I want to get a SUM of the last Column
This is what I have so far.
ExecuteSQL ( "
SELECT O.Role , R.Recommended , (A.ONE)
FROM R.Recommended AS R
JOIN Assigned AS A ON A.IDrole = R.IDrole
JOIN Roles AS O ON R.IDrole= O.IDrole
WHERE R.IDevent =?
ORDER BY O.Sort
" ; "" ; "" ; Events::IDevent)
It generates This. I need to combine the similar job into one line with the Second column and the Sum of the Last