Hi,
I want to join 2 tables
Mark that the discription is in the ref table and also the possible answer values (as columns 1, 2 3).
How would you approach this?
DataTable
ID A
100 1
101 2
102 3
RefTable
QuestionID Discription 1 2 3
A How you feeling? Awesome Good Bad
Needed output
ID How you feeling?
100 Awesome
101 Good
102 Bad



