UPDATE t_ck_kcb SET kcsl=kcsl-ck_sl,je=je - ck_je,dj=(je - ck_je) / (cksl - ck_sl)
FROM (SELECT ck,cpbm,'ck_sl'=sum(cksl),'ck_je'=sum(je) FROM t_ck_ckdmx where ck='A'
GROUP BY ck,cpbm) AS LSJ
WHERE t_ck_kcb.ck=LSJ.ck AND t_ck_kcb.cpbm=LSJ.cpbm 提示:消息 207,级别 16,状态 1,第 1 行
列名 'cksl' 无效。查询没问题:SELECT ck,cpbm,'ck_sl'=sum(cksl),'ck_je'=sum(je) FROM t_ck_ckdmx where ck='A'
GROUP BY ck,cpbm
ck cpbm ck_sl ck_je
A 001 1.00 1.0000
FROM (SELECT ck,cpbm,'ck_sl'=sum(cksl),'ck_je'=sum(je) FROM t_ck_ckdmx where ck='A'
GROUP BY ck,cpbm) AS LSJ
WHERE t_ck_kcb.ck=LSJ.ck AND t_ck_kcb.cpbm=LSJ.cpbm 提示:消息 207,级别 16,状态 1,第 1 行
列名 'cksl' 无效。查询没问题:SELECT ck,cpbm,'ck_sl'=sum(cksl),'ck_je'=sum(je) FROM t_ck_ckdmx where ck='A'
GROUP BY ck,cpbm
ck cpbm ck_sl ck_je
A 001 1.00 1.0000
FROM (SELECT ck,cpbm,'ck_sl'=sum(cksl),'ck_je'=sum(je) FROM t_ck_ckdmx where ck='A'
GROUP BY ck,cpbm) AS LSJ
WHERE t_ck_kcb.ck=LSJ.ck AND t_ck_kcb.cpbm=LSJ.cpbm
把红色的引号去掉