What SQL do I need to say, pivot, a table? For example: I have a view that shows multiple rows of one record because it can be called differently:
1 abdominal aorta
I would like to create a view that looks like:
ID Name 1 Name 2 Name 3
1 abdomen abdominal abdominal aorta
And how to you deal with the variable number of columns?
I am happy if I can just get:
ID Name string
1 abdomen,abdominal,abdominal aorta
Thanks in advance to your help!
Click Here to Expand Forum to Full Width