title: sql - join without duplicating the key
body: <p>I want to join two tables with several hundred columns, like this:</p>
  
  <pre><code>select * from a, b where a.key = b.key
  </code></pre>
  
  <p>The problem is that I get a table that has</p>
  
  <pre><code>Key | Key | Row1 | etc...
  </code></pre>
  
  <p>Without naming all of the columns explicitly ("<code>select a.key, row1, ... from a, b where a.key = b.key</code>"), is there a way I can limit the query so that it only returns one of the keys?</p>