title: MySQL Join SUM query
body: <p>Thank you for looking at my issue.<br>
  Right now I have 3 tables:</p>
  
  <ul>
  <li>tblEmployee</li>
  <li>tblEvents</li>
  <li>tblPoints</li>
  </ul>
  
  <p><strong>tblEmployee</strong></p>
  
  <p>Employee_id<br>
  First_Name<br>
  Last_Name<br>
  Email<br>
  Team   </p>
  
  <p><strong>tblEvents</strong></p>
  
  <p>Events_id<br>
  Event_Date<br>
  Event_Name<br>
  Points<br>
  Active   </p>
  
  <p><strong>tblPoints</strong></p>
  
  <p>Points_id<br>
  Employee_id<br>
  Events_id   </p>
  
  <p>Here is the query I am currently running:</p>
  
  <pre><code>SELECT tblEmployee.First_Name, tblEmployee.Last_Name, tblEvents.Points
  FROM tblEvents INNER JOIN (tblEmployee INNER JOIN tblPoints
  ON tblEmployee.Employee_id = tblPoints.Employee_id) 
  ON tblEvents.Events_id = tblPoints.Events_id;
  </code></pre>
  
  <p>This query returns all rows within the Points table but I need it to only return one row, per employee, with the points column being SUM.  I have tried this but end up with one row that sums all points.  Any thoughts?</p>