title: SQL - Select Columns from table where another table column value equals column name list
body: <p>seen a lot of similar posts about parsing data based on values but nothing quite what I want to get the result column from one table that contains the column names for another table. For example:</p>
  
  <pre><code> Select [col1], [col2]
   from Table1
   where (select changes as (col#)
          from table2)
  </code></pre>
  
  <p>The col# is a list of the column names I want from Table1. Table2 changes column is a comma separated list. I wanted to figure a way to be able to get each column from Table1 that's in the list from table2. Any help is greatly appreciated.</p>