borgkling2003
MIS
This is my current table
ID | Q_ID | A_ID
----------------
11 | 11 | 100
11 | 12 | 200
11 | 13 | 333
11 | 14 | 344
12 | 11 | 555
12 | 15 | 557
12 | 16 | 577
Can someone show me a QUERY how to display it in the following format:
ID |11 | 12 | 13 | 14 | 15 |16
-------------------------------
11 |100|200 |333 |344 | |
12 |555| | | |557 |577
ID | Q_ID | A_ID
----------------
11 | 11 | 100
11 | 12 | 200
11 | 13 | 333
11 | 14 | 344
12 | 11 | 555
12 | 15 | 557
12 | 16 | 577
Can someone show me a QUERY how to display it in the following format:
ID |11 | 12 | 13 | 14 | 15 |16
-------------------------------
11 |100|200 |333 |344 | |
12 |555| | | |557 |577