SQL - display by query the table, groups of rows as columns : i am trying to take range of codes in one column and display their results under one column per catgory<br>
<br>
example of my table <br>
ID | TEST_NUM | RESULT | <BR>

1  |    R1    |   33   |<BR>
1  |    R2    |   31   |<BR>
1  |    C1    |   24   |<BR>
1  |    C2    |   19   |<BR>

by quert from table above i am trying to get the next table:
<BR><br>
ID | TEST_NUM OF R ONLY | R RESULTS | C RESULTS | <BR>

1  |    R1    |   33   | 24 <BR>
1  |    R2    |   31   | 19 <BR>
