34,594
社区成员
发帖
与我相关
我的任务
分享
update A set A.gz=B.pjgz,A.FL=B.FL
from A,B
where A.BMH=B.BMH AND A.NF='2010'
update a
set gz=pjgz,
fl=pjfl
from a,b
where a.nf=b.nf and a.bmh=b.bmh
update A set 工资GZ = 平均工资PJGZ from A,B where A.NF=B.NF And A.BMH=B.BMH
update A set A.gz=B.pjgz
from A,B
where A.BMH=B.BMH AND A.NF=B.NF
update a set gz=b.pjgz
from a , B where a.nf=b.nf and a.bmh=b.bmh
update a
set gz=pjgz
from a,b
where a.nf=b.nf and a.bmh=b.bmh
??