语句是update xiao set xiao.作废=KK.数量
from
(select kk.编码,sum(出库) as 数量
from [select out.类别,out.编码,outdl.出库 from out inner join outdl
on out.编号=outdl.编号].as KK where 类别='损耗' group by KK.编码)
where xiao.编码=KK.编码提示出错,我真不晓得咋弄了.
from
(select kk.编码,sum(出库) as 数量
from [select out.类别,out.编码,outdl.出库 from out inner join outdl
on out.编号=outdl.编号].as KK where 类别='损耗' group by KK.编码)
where xiao.编码=KK.编码提示出错,我真不晓得咋弄了.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货