title: SQL query to get values of schema table row value in data table's column value
body: <p>There are 2 database tables as shown below, <code>Table_1</code> &amp; <code>Table_2</code>. </p>
  
  <p><code>Table_1</code> column <code>index</code> is match with <code>id</code> value of <code>table_2</code>. </p>
  
  <p><strong>Table_1</strong></p>
  
  <pre><code>| date      |city_1 | city_2 | ... | city_100 |
  +-----------+-------+--------+-----+----------+
  | 20.02.2018|   2   |   44   | ... |    98    |
  | 21.02.2018|   1   |   25   | ... |    17    |
  |    ...    |  ...  |   ...  | ... |   ...    |
  </code></pre>
  
  <p><strong>Table_2</strong></p>
  
  <pre><code>|  id   |   name  |
  +-------+---------+
  |   1   | newyork |
  |   2   | london  |
  |  ...  |   ...   |
  |  100  | istanbul|
  </code></pre>
  
  <p>Expected result is below</p>
  
  <pre><code>  |  date     |   city_1   |   city_2   |  ...  |  city_100 |
    +-----------+------------+------------+-------+-----------+
    | 20.02.2018|   london   |   india    |  ...  |  canada   |
    | 21.02.2018|  newyork   |  srilanka  |  ...  |  austria  |
    |   ...     |    ...     |    ...     |  ...  |    ...    |
  </code></pre>
  
  <p>What is the SQL query to get result above?</p>
  
  <p>Thanks</p>