求一条UPDATE语句

[cbcool]

条件：T1里按年份月份放着相同的结构，（每个月的RID结构相同）
目的：把T1中5月份的P1值更新到6月份中对应的P1中
我的思路：把5的值select出来看作表b,然后根据表B更新表T1中的P1值
update T1
set a.P1 = b.P1
from T1 a,(select RID,P1 from T1 where Year = 2004,Month = 5) b
where a.RID = b.RID
and a.Year = 2004
and a.Month = 6

但是出错，请问该怎么写？谢谢！不想写存储过程，只想一条SQL语句搞定:)

[cbcool]

真的结不了,我的密码是174615,哪位老兄帮我结了吧谢谢

[zjcxc]

帮助你结,你也要说明给分给那些人,给多少啊

[zjcxc]

update T1
set P1 = b.P1
from T1 a,(select RID,P1 from T1 where Year = 2004 and Month = 5) b
where a.RID = b.RID
and a.Year = 2004
and a.Month = 6

[zjcxc]

update t1 set p1=b.p1
from t1 a,(
select rid,p1 from t1 where [year]=2004 and [month]=5
)b
where a.RID = b.RID
and a.[Year] = 2004
and a.[Month] = 6

[pisces007]

update T1
set P1 = a.P1
from T1 a inner join (select RID,P1 from T1 where Year = 2004 and Month = 5) b
on a.RID = b.RID
where a.Year = 2004
and a.Month = 6

[chludlf]

update a

set P1 = b.P1

from T1 a,(select RID,P1 from T1 where Year = 2004,Month = 5) b
where a.RID = b.RID
and a.Year = 2004
and a.Month = 6

[victorycyz]

update t1
set P1 = (select P1 from t1 where rid=a.rid and year=2004 and month=5)
from t1 a
where year=2004 and month=6

[pisces007]

update T1
set P1 = b.P1
from T1 a inner join (select RID,P1 from T1 where Year = 2004 and Month = 5) b
on a.RID = b.RID
where a.Year = 2004
and a.Month = 6

[leeboyan]

update t1 set p1=(select p1 from t1 a join t2 b on a.RID = b.RID where b.Year = 2004 and b.Month = 6 and a.Year = 2004 and a.Month = 5)

[cbcool]

谢谢！

[cbcool]

怎么结贴老是出错呀？

[leeboyan]

管理-〉给分->输密码->确定

[cbcool]

zjcxc(邹建)给50，pisces007(蝶鱼)给20，其它的分别给10，再后面的没了就不给了：）谢谢！