troubleshooting Question

Make query as fixed table

Avatar of ullenulle
ullenulleFlag for United States of America asked on
MySQL Server
13 Comments2 Solutions117 ViewsLast Modified:
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

Sharath S
Data Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros