title: MySQL merge 2 tables with same Id values
body: <p>I have a MySQL db that has 2 tables that have related information that I need to merge to 1 table.</p>
  
  <p><code>Gallery</code> has an <em>itemid</em> that relates to <code>rbitems</code> <em>Id</em>. Both tables <code>gallery</code> and <code>rbitems</code> have different column names but both have unique data. I want to merge the two tables based on the <em>Id</em> and <em>itemid</em> columns.</p>
  
  <p>So how do I merge 2 different tables into 1 based on 1 column having unique values. I'd like to just append the other tables to the merge.</p>