Avatar of ullenulle
Flag for United States of America

asked on 

Make query as fixed table

Hi there.

I have a query, that I may save as a view. That query/view contains a number of variables. One of them though can take either value A or B (arm A and B). So I want to evaluate all variables row by row distributed on the arms in columns like this:
              Arm A     Arm B
Var 1    eval 1a     eval 1b
Var 2    eval 2a     eval 2b
Var 3    eval 3a     eval 3b
Var 4    eval 4a     eval 4b
....         ....              ....
and so on and on...

How do I formulate the query?
Thank you in advance. :-)

Best regards

MySQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon