l******9
发帖数: 579 | 1 On SQL Server 2008 R2, I need to add some columns into a table from another
table.
e.g.
Table1:
name value id
Jim 288 abf
Table 2:
name acct num rank
Jim 12 29 8
Jim 98 95 7
Jim 20 52 9
What I need:
name value id acct num rank acct num rank acct num rank
Jim 288 abf 12 29 8 98 95 7 20 52 9
The record numbers in table 2 may be variable.
Any help would be appreciate. | a***x
发帖数: 26368 | 2 真是没完没了了啊
another
【在 l******9 的大作中提到】
: On SQL Server 2008 R2, I need to add some columns into a table from another
: table.
: e.g.
: Table1:
: name value id
: Jim 288 abf
: Table 2:
: name acct num rank
: Jim 12 29 8
: Jim 98 95 7
|
|
