Merge data for graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table which has 4 columbs for the same thing, this is because for
each record there are upto 4 possible outcomes. To generate a graph i would
like to have the data from the 4 columbs to be evaluated as one columb
instead of 4.

The table looks like this

action_taken_1 | action_taken_2 | action_taken_3 | action_taken_4
7 | 2 | 6 |
1
2 | 9 | 4 |
7

I think an update query is what i may need but i am not sure where i am
writing the statement to execute this.
 
Back
Top