Is there any way to get table T3 (below) from T1 and T2 using SQL (select, view, etc)?
T3 is basically all INDEX values from T1 matched to IND from T2 with the corresponding
KEY/VALUE pairs transposed from rows to columns.
-------
|INDEX| (T1)
-------
| 1 |
| 2 |
| 3 |
-------
-----------------
|IND|KEY| VALUE | (T2)
-----------------
| 1 | 1 | val_a |
| 1 | 2 | val_b |
| 1 | 3 | val_c |
| 2 | 1 | val_d |
| 2 | 2 | val_e |
| 3 | 1 | val_f |
| 3 | 3 | val_g |
-----------------
----------------------------------
|T1_INDEX|KEY1VAL|KEY2VAL|KEY3VAL| (T3)
----------------------------------
| 1 | val_a | val_b | val_c |
| 2 | val_d | val_e | |
| 3 | val_f | | val_g |
----------------------------------
Thanks for any suggestions
med vänlig hälsning
/Dana
