title: Combining 2 databases to create a table with a common column
body: <p>I need to create a table that will combine two database tables together. Both databases have a table that share a common column:  core.</p>
  
  <p>So I need each row to show the common "core".</p>
  
  <p>Do I need to create a separate database to achieve this?</p>
  
  <pre><code>Database: hero
  Table: cartons_current
  +---------+
  | date    |
  +---------+
  | core    |
  +---------+
  | qty     |
  +---------+
  
  Database: hero_label
  Table: labels_current
  +---------+
  | date    |
  +---------+
  | core    |
  +---------+
  | qty     |
  +---------+
  </code></pre>