title: Map table names of a database with values in another table
body: <p>I have some table names in <code>test</code> database in MySQL. I have a table called <code>mapping</code> in database <code>renamed</code> that has information of tables that have been renamed.</p>
  
  <p>Now I want to have a list of the tables that are in <code>test</code> database and their renamed name in the <code>mapping</code> table.</p>
  
  <p>Tables in <code>test</code></p>
  
  <pre><code>123_abc
  124_abc
  235_test
  </code></pre>
  
  <p>Information in <code>mapping</code> table</p>
  
  <pre><code>table       renamed
  
  123_abc     123_abc_test
  235_test    235_testing
  abc_test    abc_test1
  </code></pre>
  
  <p>Now I want a list that contains table names that are in <code>test</code> database and their renamed names in the <code>mapping</code> table in <code>renamed</code> database</p>
  
  <p>The expected result is</p>
  
  <pre><code>123_abc     123_abc_test
  235_test    235_testing
  </code></pre>
  
  <p>How can I achieve that?</p>