title: MySQL - specific columns on join?
body: <p>When making a join (inner, left outer, right outer or whatever), how can I specify which columns on the table to join into the original table?</p>
  
  <p>Consider the following example:</p>
  
  <pre><code>SELECT FirstName FROM User LEFT OUTER JOIN Provider ON User.ProviderID = Provider.ID
  </code></pre>
  
  <p>This would select FirstName from user, but select everything from Provider. How can I specify which parts of Provider should be included in the resultset?</p>