SELECT Emp.employeeK, Emp.lastname, Emp.firstname, tblSite.name as 'Location' , SUM(totalkms) as TotalKMs FROM tblEmployee Emp INNER JOIN tblReimbursements reim ON Emp.employeeK = reim.employeeFK INNER JOIN tblSite ON siteK = siteFK GROUP BY Emp.employeeK