语句是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.编码提示出错,我真不晓得咋弄了.
常规差错办法:先在sql plus里执行看是否正确完成,然后再判断是sql语句问题还是程序问题。
from [select out.类别,out.编码,outdl.出库 from out inner join outdl
on out.编号=outdl.编号].as KK where 类别='损耗' group by KK.编码這句很明顯有問題!仔細看看!
from [select out.类别,out.编码,outdl.出库 from out inner join outdl
on out.编号=outdl.编号].as KK where 类别='损耗' group by KK.编码
这一句是单独执行通过了的
这里,方括号改成(),后面的as KK前面多了一点,去掉,留个空格。
学习中,以前还真没用过,select 一张表作为from后的,原来还有这用法
[]与()的区别