17,377
社区成员
发帖
与我相关
我的任务
分享
update T_BD_MaterialInventory a
set a.funitid=(select b.fbaseunit
from T_BD_Material b
where b.fid=a.fmaterialid
and b.fbaseunit <> a.funitid
and rownum = 1)
这个应该是可以的
update T_BD_MaterialInventory a
set a.funitid=(select b.fbaseunit
from T_BD_Material b
where b.fid=a.fmaterialid
and b.fbaseunit <> a.funitid )