update temp_print_1 set day_number=
(select sum(day_number) as day_number from ky_sgp_jp group by crew_id)
where temp_print_1.crew_id=ky_sgp_jp.crew_id
就是想把 group by 汇总出来的数【day_number】,按【crew_id】替换到temp_print_1表中。可就是出错 ,到底 该怎么写,求高手给指点迷金。 谢谢!
(select sum(day_number) as day_number from ky_sgp_jp group by crew_id)
where temp_print_1.crew_id=ky_sgp_jp.crew_id
就是想把 group by 汇总出来的数【day_number】,按【crew_id】替换到temp_print_1表中。可就是出错 ,到底 该怎么写,求高手给指点迷金。 谢谢!
as(
select crew_id,sum(day_number) as day_number from ky_sgp_jp group by crew_id
)
update temp_print_1 set temp_print_1.day_number=a.day_number from t a
where [temp_print_1].crew_id=a.crew_id
update temp_print_1 set [temp_print_1].day_number=a.day_number from (
select crew_id,sum(day_number) as day_number from ky_sgp_jp group by crew_id
) a where [temp_print_1].crew_id=a.crew_id
列名 'day_number' 无效。
----------------------------
不好意思,发错了,全部运行提示的是这个。