update xx_hy_info set xx_hy_info.hy_num=b.hy_num
from (select hy_id,sum(hy_num_move) as hy_num
from hy_num_move_ls group by hy_id) b
where xx_hy_info.hy_id=b.hy_id上面语句在sql server中执行正常,但是把数据库换成access之后,就无法执行了,提示“操作符丢失”。什么原因呀?
from (select hy_id,sum(hy_num_move) as hy_num
from hy_num_move_ls group by hy_id) b
where xx_hy_info.hy_id=b.hy_id上面语句在sql server中执行正常,但是把数据库换成access之后,就无法执行了,提示“操作符丢失”。什么原因呀?
set xx_hy_info.hy_num=b.hy_num
from xx_hy_info a
left join (select hy_id,sum(hy_num_move) as hy_num from hy_num_move_ls group by hy_id) b
on a.hy_id=b.hy_id
在access数据执行还是错误
--类似这样在情况
update bb b left join aa a on b.id = a.id set b.name = a.nameupdate
xx_hy_info a
left join (select hy_id,sum(hy_num_move) as hy_num from hy_num_move_ls group by hy_id) b
on a.hy_id=b.hy_id
set a.hy_num=b.hy_num