title: SQL Joins to Get Monthly Total Wages from Three Tables
body: <p>I need to get <code>empolyees</code> info from <code>employees table</code>, and their total wages from two different tables.</p>
  
  <p>The SQL is approximately like this, but I don't really know how to use joins to do this:</p>
  
  <ul>
  <li><code>CONCAT(first_name, ' ', last_name) from employees as e</code></li>
  <li><code>Sum(hours*pay) where date is "THIS MONTH" and employee_id = e.id from taxed_work</code></li>
  <li><code>Sum(hours*pay) where date is "THIS MONTH" and employee_id = e.id from nontaxed_work</code></li>
  </ul>
  
  <p>I am not sure how to join these together properly. I don't want to see any of the employees that have not done either kind of work for the month, only those who have. I'm using mysql and will put the data in a table with php</p>
  
  <p>If anyone could tell me how to do the "THIS MONTH" part that would be cool too. Just being lazy on that part, but figured while I was here...</p>
  
  <p>Thanks for the help!</p>