title: #1060 - Duplicate column name
body: <p>Why does this query errors <code>(1060) Duplicate column name 'studentID'</code> in MySQL? How can I prevent it?</p>
  
  <pre><code>CREATE TEMPORARY TABLE tempTable 
      select * from member_infos 
      join contact_infos on member_infos.studentID=contact_infos.studentID
  </code></pre>