Unanswered: different column depending on other columns
need help with get data from correct column depending on the data in other columns
The table looks like this
type1, name1, type2, name2, type3, name3
type* column is INT and name* column is varchar
if column type1 = 1 and column type2 = 1 and column type3 = 3 then result should be from column name1
if column type1 = 2 and column type2 = 1 and column type3 = 2 then result should be from column name3
and so on with various code.
I have try "case" in many different ways but i just cant get it to work the way i want it.