j*****o 发帖数: 320 | 1 Table data:
id Value1 Value2
1 1-1 1-2
1 2-1 2-2
2 3-1 3-2
3 4-1 4-2
3 5-1 5-2
3 6-1 6-2
怎么才能输出:
id Value
1 1-1 1-2 2-1 2-2
2 3-1 3-2
3 4-1 4-2 5-1 5-2 6-1 6-2
谢谢. |
x***e 发帖数: 2449 | 2 I think you might want to use a cursor in this case, or write some code.
it is not a simple join/union ymmo.
【在 j*****o 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Table data: : id Value1 Value2 : 1 1-1 1-2 : 1 2-1 2-2 : 2 3-1 3-2 : 3 4-1 4-2 : 3 5-1 5-2 : 3 6-1 6-2 : 怎么才能输出: : id Value
|
j*****o 发帖数: 320 | 3 多谢两位。
【在 x***e 的大作中提到】![](/moin_static193/solenoid/img/up.png) : I think you might want to use a cursor in this case, or write some code. : it is not a simple join/union ymmo.
|
x***e 发帖数: 2449 | 4 np
【在 j*****o 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 多谢两位。
|