英语翻译update#GzCalsetC21C2109=加点时间from(selecta0188asa0188,sum(isnull(C121.C12109,0))加点时间fromC121where1=1and(isnull(C121.C12107,'##')=:GZYM)groupbya0188)awherea.a0188=#GzCal.a0188and[工资构成]in('职能管

Question

英语翻译
update #GzCal
set C21_C2109=加点时间
from
(select a0188 as a0188,
sum(isnull(C121.C12109,0)) 加点时间
from C121
where 1=1
and (isnull(C121.C12107,'##')=:GZ_YM)
group by a0188
) a
where a.a0188=#GzCal.a0188
and
[工资构成] in ('职能管理制1')

Answer 1

应该是括号中的临时表,省略了as