title: sql join ORA-00918: column ambiguously defined
body: <p>I have two tables A and B, and try to select them by sql <code>INNER JOIN</code>, but I run into this error:</p>
  
  <blockquote>
    <p>ORA-00918: column ambiguously defined</p>
  </blockquote>
  
  <p>I guess it is because there are two columns' name in these two tables are the same, that is <code>A.column1</code>, <code>B.column1</code> and <code>A.column2</code> and <code>B.column2</code> (These two columns' name in A and B are the same). Since these two tables are stored in the server, I can not rename the columns. So what can I do?</p>
  
  <p>This is the code I use:</p>
  
  <pre><code>Select * FROM A INNER JOIN B WHERE A.column1 = B.column1.
  </code></pre>
  
  <p>How can I fix it?</p>