title: CREATE TABLE failed ORA 00957 Duplicate column name
body: <p>As I tried to create new table from existing 2 table with specific column name in oracle. </p>
  
  <p>I tried below code</p>
  
  <pre><code>CREATE TABLE D_T1
  AS
     SELECT a.col1, a.col2, a.col3, a.col4, a.col5, b.col6, b.col7, b.col8
     FROM db1.table1 a INNER JOIN db1.table2 b
     ON (a.col1 = b.colNum AND a.col2 = b.colnum1)
  </code></pre>
  
  <p>But I get error </p>
  
  <blockquote>
    <p>CREATE TABLE failed ORA 00957 Duplicate column name</p>
  </blockquote>
  
  <p>Can anyone help?</p>