Mysql query question: I want to run a join query that selects columns from table A based on values in table B. Namely table B contains the column names for table A.
EX: Select table_B.col_table_A from table_A JOIN table_B on table_A.key = table_B.a_key
The columns names selected are from table A are stored in tale B.
thanks in advance

I'm basically looking for a way for mysql to treat the value as a column name and not a value

"select *.t1, a_key.t2 from table1 t1, table2 t2 where t1.a_key=t2.a_key";