<div>
Didn't understand completely. How many variables you have?
</div>

<div>
What does your schema look like? 
 
What does the data in the table look like? 
 
The information you have provided is not enough for us to understand the question.
</div>

<div>
Hi again. 
 
Sorry for not providing enough info. I'll try harder. :-) 
I can't show the specific variables, but consider I have a source table like this: 
 
tbl_source 
 
... with variables: 
 
var_1 
var_2 
var_3 
var_4 
var_5 
 
var_2 can only take the values A and B - as I call arm A and arm B. 
var_1 is an ID. 
The rest can be any value, and I want to make a table showing the distribution of the variables var_3, var_4 and var_5 like this: 
 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Arm_A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Arm_B 
var_3 &nbsp;if=1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; eval_3a_1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eval_3b_1 
var_3 &nbsp;if=2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; eval_3a_2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eval_3b_2 
var_3 &nbsp;if=3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; eval_3a_3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eval_3b_3 
var_4 &nbsp;if=right &nbsp; &nbsp; &nbsp; eval_4a_right &nbsp; &nbsp; &nbsp;eval_4b_right 
var_4 &nbsp;if=left &nbsp; &nbsp; &nbsp; &nbsp; eval_4a_left &nbsp; &nbsp; &nbsp; &nbsp; eval_4b_left 
var_5 &nbsp;if=yes &nbsp; &nbsp; &nbsp; &nbsp; eval_5a_yes &nbsp; &nbsp; &nbsp; &nbsp; eval_5b_yes 
var_5 &nbsp;if=no &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eval_5a_no &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;eval_5b_no 
var_5 &nbsp;if=maybe &nbsp; eval_5a_maybe &nbsp;eval_5b_maybe 
var_5 &nbsp;if=n/a &nbsp; &nbsp; &nbsp; &nbsp; eval_5a_n/a &nbsp; &nbsp; &nbsp; &nbsp; eval_5b_n/a 
 
So I need to make a query, that look in a way like this (not correct syntax at all (!!!!), but to explain what I want. :-) 
 
SELECT 
CASE WHEN var_2='A' THEN SUM(CASE WHEN var_3=1 THEN var_3 ELSE 0 END) END AS Arm_A, 
CASE WHEN var_2='B' THEN SUM(CASE WHEN var_3=1 THEN var_3 ELSE 0 END) END AS Arm_B, 
CASE WHEN var_2='A' THEN SUM(CASE WHEN var_3=2 THEN var_3 ELSE 0 END) END AS Arm_A, 
CASE WHEN var_2='B' THEN SUM(CASE WHEN var_3=2 THEN var_3 ELSE 0 END) END AS Arm_B, 
... and so and on... 
FROM tbl_source 
 
I know very well, that the above won't work! The first 2 lines could work, but I kinda need to make some &quot;GROUP BY&quot; that will group on the optional values of var_3 to var_5. 
 
I'm afraid this is the best I can explain it. The real world won't make it any better! Believe me. :-) 
 
I hope you got an idea of my question now? 
 
Best regards 
 
Ulrich
</div>

<div>
Can you explain with some sample data from your table and expected result? 
The creation of second table may be avoided if the requirement is clear. Looks like you need a dynamic query, but please provide some sample data.
</div>

<div>
Sure. Here's how the source could look like: 
 
Record no. &nbsp; &nbsp; var_1 &nbsp; &nbsp; var_2 &nbsp; &nbsp; var_3 &nbsp; &nbsp; var_4 &nbsp; &nbsp; var_5 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; no 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;maybe 
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;n/a 
4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; &nbsp;yes 
5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; &nbsp;maybe 
6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; yes 
7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; &nbsp;no 
8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; &nbsp;yes 
9 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;no 
10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; no 
 
The result, I want to obtain with a query, would look like this with the sample above: 
 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Arm_A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Arm_B 
var_3 &nbsp;if=1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 
var_3 &nbsp;if=2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 
var_3 &nbsp;if=3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 
var_4 &nbsp;if=right &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 
var_4 &nbsp;if=left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 
var_5 &nbsp;if=yes &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 
var_5 &nbsp;if=no &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 
var_5 &nbsp;if=maybe &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 
var_5 &nbsp;if=n/a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1
</div>

<div>
How did you derive 3 for var_3 if=1 and Arm_A? 
For var_3 if=1, there are 5 records with Var_2 as A. Isn't is sum of all var_2 values for highlighted records. 
Record no. &nbsp; &nbsp; var_1 &nbsp; &nbsp; var_2 &nbsp; &nbsp; var_3 &nbsp; &nbsp; var_4 &nbsp; &nbsp; var_5 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; no 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;maybe 
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;n/a 
4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; &nbsp;yes 
5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; &nbsp;maybe 
6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; yes 
7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; &nbsp;no 
8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; &nbsp;yes 
9 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;no 
10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; no
</div>

<div>
In case var_2=A, then var_3 hold the value &quot;1&quot; 3 times as marked bold: 
 
Record no. &nbsp; &nbsp; var_1 &nbsp; &nbsp; var_2 &nbsp; &nbsp; var_3 &nbsp; &nbsp; var_4 &nbsp; &nbsp; var_5 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; no 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;maybe 
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;n/a 
4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; &nbsp;yes 
5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; &nbsp;maybe 
6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; yes 
7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; &nbsp;no 
8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; &nbsp;yes 
9 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;left &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;no 
10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;right &nbsp; &nbsp; &nbsp; no
</div>

<div>
Ok. how many variables you have? Do you know the distinct values in those variables like var_3 has 1,2,3 values and var_4 = right, left etc. 
Or do you want to derive them dynamically?
</div>

<div>
There's like 35 variables, and they can all be categorized like left/right, specific values etc... There's no unknown values. Data has been entered via drop down menus or check boxes. That way there's limited options for each variable.
</div>

ullenulle

<div>
Hi there. 
 
Forgive me for not responding. I've been caught up other urgent assignments. I'll be back in a few days. 
 
Best regards 
 
Ulrich
</div>

<div>
<div class="content wysiwyg-content">
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: 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Arm A &nbsp; &nbsp; Arm B 
Var 1 &nbsp; &nbsp;eval 1a &nbsp; &nbsp; eval 1b 
Var 2 &nbsp; &nbsp;eval 2a &nbsp; &nbsp; eval 2b 
Var 3 &nbsp; &nbsp;eval 3a &nbsp; &nbsp; eval 3b 
Var 4 &nbsp; &nbsp;eval 4a &nbsp; &nbsp; eval 4b 
.... &nbsp; &nbsp; &nbsp; &nbsp; .... &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.... 
and so on and on... 
 
How do I formulate the query? 
Thank you in advance. :-) 
 
Best regards 
 
Ulrich
</div>
</div>

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

Ulrich

Make query as fixed table

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.