34,590
社区成员
发帖
与我相关
我的任务
分享
update INVMB set MB003=a.NEWSIZE from CHANGE a where ...
update invmb set mb003=newsize from [change] where invmb.name=[change].name
update INVMB set MB003=B.NEWSIZE from INVMB A,CHANGE B where A.NAME=B.NAME
update INVMB
set MB003=newsize
from INVMB a,CHANGE b
where a.name=b.name