update a set field1= (select max(field2) from a,b where A.EMPLID = B.EMPLID) where exists(select 1 from b where A.EMPLID = B.EMPLID); 如果你查询出的field2不唯一的话,你应该根据你的实际情况去选择是用什么样的值去更新field1这里我是例举用最大值去更新
update a set field1= (select max(field2) from b where A.EMPLID = B.EMPLID) where exists(select 1 from b where A.EMPLID = B.EMPLID);前面错了一点
update a set a.FIELD1=B.FIELD2 where exists (select 1 from B where B.emplid=a.emplid) -- 这样不能执行呀 !!!!
where exists (select 1 from B where B.emplid=a.emplid)
Update A Set A.F1=B.F2
Where Exists (Select 1 From B Where B.ID=A.ID)
原来还可以这样:
Update A Set A.F1=B.F2
Where Exists (Select 1 From B Where B.ID=A.ID)
执行以上指令,会提示记录不唯一.各位看看有啥高招?!!!!!!!!! 稍等,下次再散分吧!!!! 呵呵
where exists (select 1 from B where B.emplid=a.emplid) -- 这样不能执行呀 !!!!