50分求助:如何写这样的一条更新语句

[yixian2007]

唯一列:gradeid
第一列:courcredit
第二列:getcredit
第三列:archment

当courcredit与getcredit的值不同的时候,并且同时archment满足一定条件时,将getcredit的值更新为courcredit的值.

蓝色为条件,红色为要做的行为.

[yygyogfny]

update tableA set getcredit = courcredit where courcredit <> getcredit and archment 的条件

[Rotel-刘志东]

update tab set getcreadit=courcredit where courcredit=getcredit and archment='Bule'

[htl258_Tony]

update tb set getcredit=courcredit where courcredit<>getcredit and archment ='你的条件'

[Rotel-刘志东]

不好意思上边写错了。

update tab set getcreadit=courcredit where courcredit<>getcredit and archment='Bule'

[lgxyz]

UPDATE TB SET GETCREDIT=COURCREDIT WHERE COURCREDIT<>GETCREDIT AND ARCHMENT........

[ws_hgo]

[Quote=引用楼主 yixian2007 的帖子:]
唯一列:gradeid
第一列:courcredit
第二列:getcredit
第三列:archment

当courcredit与getcredit的值不同的时候,并且同时archment满足一定条件时,将getcredit的值更新为courcredit的值.

蓝色为条件,红色为要做的行为.
[/Quote]

update tb set getcredit=courcredit where courcredit<>getcredit and archment=...

[jwdream2008]

update tb set getcredit=(case when (courcredit<>getcredit and archment=条件)then courcredit else getcredit end)

[sdhdy]

update tb set getcredit=courcredit where courcredit<>getcredit and archment 条件

[ks_reny]

update tableA 
set getcredit = courcredit 
where courcredit <> getcredit and archment 的条件

[yubudian]

update table
 set getcredit=(case when (courcredit <>getcredit and archment=条件)then courcredit  else getcredit end)

[ai_li7758521]

update tb 
set getcredit = courcredit 
where courcredit<>getcredit and archment 满足条件

[lvoers]

update tb set getcredit = courcredit
where courcredit<>getcredit and archment = '你的条件'

[henry_gz]

唯一列:gradeid
第一列:courcredit
第二列:getcredit
第三列:archment

当courcredit与getcredit的值不同的时候,并且同时archment满足一定条件时,将getcredit的值更新为courcredit的值.

蓝色为条件,红色为要做的行为.

update tbl set getcredit=courcredit where courcredit!=getcredit and archment ='满足条件'

[yixian2007]

结贴给分了.