title: Better way to select all columns from first table and only one column from second table on inner join
body: <h2>Graphical Explaination</h2>
  
  <p>Table 1's columns:</p>
  
  <pre><code>|a|b|c|d|e|
  </code></pre>
  
  <p>Table 2's columns:</p>
  
  <pre><code>|a|x|y|z|
  </code></pre>
  
  <p>I want only a, b, c, d, e, x.  I only want column 'a' from table 1, not column 'a' from table 2.</p>
  
  <h2>Wordy Explaination</h2>
  
  <p>I have two tables with one column sharing a common name.  If I use a Select * and use an inner join, I get all the columns returned including two columns with the same name.  </p>
  
  <p>I want to select everything from the first table, and only one column from the second table.  Right now I am specifing every single column I need, which is a drag.  Is there an easier way to grab everything from the first table and only the one column I want from the second table?</p>
  
  <p>Thanks in advance.  </p>