title: Amazon Redshift join variable duplicated with select *
body: <p>I'm trying to create a new table in Redshift</p>
  <p>The code used to create a new table works on it's own but when I wrap it in create table it stops working</p>
  <p>Invalid operation: column name &quot;Number&quot; is duplicated;</p>
  <pre><code>create table test
  as
  (select 
  a.*
  ,b.*
  from a
  inner join b
  on a.number = b.number
  );
  </code></pre>
  <p>Any ideas what's happening? I don't want to specify every single column of b just so i can omit b.numbe</p>