title: MySQL - How to create a new table that is a join on primary key of two existing tables
body: <p>I have two existing tables, with different fields, except for Primary ID (a <code>varchar</code>, not an <code>int</code>). I want to create a third table which is essentially a merge of these two, such that for a given Primary Key I have all fields in one table.</p>
  
  <p>How can this be done?</p>