title: MySQL Select From Map fields
body: <p>I have MySQL 2 Table like this<br/>
  <br/><strong>Table_1</strong><br/>
  <a href="https://i.stack.imgur.com/hqjmG.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hqjmG.jpg" alt="Table_1"></a>
  <br/><br/><strong>Table_2</strong><br/>
  <a href="https://i.stack.imgur.com/zjD1x.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zjD1x.jpg" alt="Table_2"></a>
  <br/><br/>And i want result table like this<br/>
  <br/><strong>Result Table</strong><br/></p>
  
  <p><a href="https://i.stack.imgur.com/nUFdB.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nUFdB.jpg" alt="Result_Table"></a></p>
  
  <p>So, I put this query <br/></p>
  
  <pre><code>SELECT A.TAG,B.VALUE
  FROM TABLE_1 A
  LEFT JOIN TABLE_2 B
  On A.CODE=B.CODE;
  </code></pre>
  
  <p>And can i create automatic map field when i want this result table i just call </p>
  
  <pre><code>SELECT TAG,VALUE FROM MAP_TABLE WHERE TAG IN('ASSX','ASPS','AAPP');
  </code></pre>