title: Make a table from from table A and table B where match
body: <p>MySQL noob here. I need to create a product catalog table from two others.  Table A has a product weight and Table B has description.  So I need to make a Table C with the weight and description of course.</p>
  
  <p>These catalogs are different, from different sources, and the only field I can match is SKU. </p>
  
  <p>Should I make Table C from a copy of Table A (with weight), then add a description column, then:</p>
  
  <pre><code>update tableC  
  join tableA on tableB.sku = tableA.sku  
  set description = tableB.description  
  </code></pre>