子查询的值多于一个的问题
这样写有什么毛病啊 怎么改啊
select

,c21.a0190

,SUM(select case when right(c105.gz_ym,2)= '01 ' then isnull(c10511,0) else 0 end from c105,c21 where c105.a0188=c21.a0188 and c105.gz_ym=c21.gz_ym) as '一月 '

from c21,deptcode,c105
where c21.dept_id=deptcode.dept_id

SUM函数 是不是不能这么用？去了SUM出现子查询的值多于一个


[解决办法]
这样？

select
c21.a0190,
SUM(case when right(c105.gz_ym,2)= '01 ' then isnull(c10511,0) else 0 end) as '一月 '
from c21
join c105
on c105.a0188=c21.a0188 and c105.gz_ym=c21.gz_ym
join deptcode
on c21.dept_id=deptcode.dept_id
group by c21.a0190
[解决办法]
select

,c21.a0190

,SUM(case when right(c105.gz_ym,2)= '01 ' then isnull(c10511,0) else 0 end ) as '一月 '

from c21,deptcode,c105
where c21.dept_id=deptcode.dept_id and c105.a0188=c21.a0188 and c105.gz_ym=c21.gz_ym