修改为下面就可以了,GROUP BY不能象你那样用的 select partno,batchno, sum(case judge when '好' then quality when '收' then quality when '发' then -quality when '换' then -quality else -quality end) 库存数 from collect group by batchno,partno;
Up!那个“库存数”前面是不是应该加个as啊?
将partno,batchno的两个位置调换一下如:batchno,partno因为group by 是对结果集分组显示,所以必须将几个字段顺序分组,你也可以是
将group by 改为: group by partno,batchno 就可以了
修改为下面就可以了,GROUP BY不能象你那样用的 select partno,batchno, sum(case judge when '好' then quality when '收' then quality when '发' then 0-quality when '换' then 0-quality else -quality end) 库存数 from collect group by batchno,partno;
说说你要做什么吧。
select partno,batchno,
sum(case judge
when '好' then quality
when '收' then quality
when '发' then -quality
when '换' then -quality
else -quality
end) 库存数
from collect
group by batchno,partno;
将group by 改为: group by partno,batchno 就可以了
select partno,batchno,
sum(case judge
when '好' then quality
when '收' then quality
when '发' then 0-quality
when '换' then 0-quality
else -quality
end) 库存数
from collect
group by batchno,partno;