I need to use the value of a selected column as column name in sub sql.
Select A.id, A.name, A.header, (Select A.name from table2 B where B.id = 2) as value from table1 A
A.name is the Clue here. that contains the column name that I need in the sub sql
How to do this ??