title: Get MySql column value with dynamic column name stored in other table
body: <p>I have two tables in MySql. In first table I have field name list and in other I have record that column name is stored in first table.</p>
  
  <p>for examlple:
  first table</p>
  
  <pre><code>|id|name|
  ---------
  |1|fieldname1|
  |2|fieldname2|
  </code></pre>
  
  <p>second table</p>
  
  <pre><code>|id|fieldname1|fieldname2|
  </code></pre>
  
  <p>I have a query with INNER JOIN between this tables, Can I get value of one of the second table row with column value of first table?</p>