两个表之间的update问题

[buddhatarzan]

我有两个表
----------------------------
T1
PK1 FK Content1
1 11 aa
2 11 bb
3 11 cc
----------------------------
T2
PK2 FK Content2
4 11
5 11
6 11
两个表唯一的关系就是FK这一列的值相同（是另外一个表的关联）， 我现在想把T1 的Content1数据逐行update到T2的Content2。怎么做？
我试过 update T2 set content2=content1 from T1,T2 where T1.FK=T2.FK, 但是结果是T2表的content2都是“aa”,没有“bb”和“cc”

[buddhatarzan]

引用 1 楼 wwhtkill 的回复:

update T2 set Con=a.Con from (select *, row_number()over(partition by fk order by pk1) n from T1)a,
(select *, row_number()over(partition by fk order by pk2) n from T2)b where a.fk=b.fk and a.n=b.n

多谢大神

[wwhtkill]

update T2 set Con=a.Con from (select *, row_number()over(partition by fk order by pk1) n from T1)a,
(select *, row_number()over(partition by fk order by pk2) n from T2)b where a.fk=b.fk and a.n=b.n

[Ginnnnnnnn]

UPDATE a SET a.Content2 =b.Content1
	FROM (SELECT *,ROW_NUMBER() OVER (PARTITION BY FK ORDER BY PK2) AS RNr FROM T2 ) a
		INNER JOIN (SELECT *,ROW_NUMBER() OVER (PARTITION BY FK ORDER BY PK1) AS RNr FROM T1 ) b ON a.FK = b.FK AND a.RNr = b.RNr

还有一个问题，如果T2数据和T1 不一致怎么搞？

[--小F--]

;with cte as 
(
select a.content1 from 
(select row_number()order by getdate()) as id,* from t1) as a
inner join 
(select row_number()order by getdate()) as id,* from t2) as b
on 
a.id=b.id and a.FK=B.FK
)
update t2 set Content2=a.Content1 from cte as a inner join t2 as b on a.id=b.id and a.FK=B.FK