用as别名条件查询问题，出现列名无效

Question

insert into jieyu (class_name,num) 
select class_name,kucun=isnull((select sum(num) from chuku where class_name=ruku.class_name),0)
from ruku
where kucun>0
group by class_name
提示列名“kucun”无效有什么方便的办法可以解决

Answer 1

insert into jieyu (class_name,num) 
select class_name,kucun=isnull((select sum(num) from chuku where class_name=t.class_name),0)
from ruku t
where kucun>0
group by class_name

Answer 2

--TRY
insert into jieyu (class_name,num) 
select class_name,kucun=isnull((select sum(num) from chuku where class_name=t.class_name),0)
from ruku t
where t.kucun>0
group by t. class_name

Answer 3

insert into
 jieyu (class_name,num) 
select
 class_name,kucun=isnull((select sum(num) from chuku where class_name=t.class_name),0)
from
 ruku t
where
 kucun>0
group by
 class_name

Answer 4

insert into jieyu (class_name,num)
select * from(
select class_name,kucun=isnull((select sum(num) from chuku where class_name=t.class_name),0)
from ruku t
group by class_name) r
where kucun>0

Answer 5

insert into
 jieyu (class_name,num) 
select
 class_name,kucun=isnull((select sum(num) from chuku where class_name=t.class_name),0)
from
 ruku t
where
 t.kucun>0
group by
 class_name

Answer 6

insert into jieyu (class_name,num) 
select class_name,kucun=isnull((select sum(num) from chuku where class_name=t.class_name),0)
from ruku t
group by class_name
having(isnull((select sum(num) from chuku where class_name=t.class_name),0)>0)

Answer 7

--语句不用写那么复杂
insert into jieyu (class_name,num)
select class_name,kucun=isnull(sum(num),0)
from ruku t
where isnull(sum(num),0) > 0
group by class_name

Answer 8

nianran520  说的对，不用写的那么麻烦insert into jieyu (class_name,num) 
select class_name,kucun=isnull(sum(num),0)
from ruku t
group by class_name
having(isnull(sum(num),0)>0)

Answer 9

--晕
select class_name,kucun=isnull(sum(num),0)
from ruku t
group by class_name
having isnull(sum(num),0) > 0 

Answer 10

insert into jieyu (class_name,num) 
select class_name,kucun =isnull((select sum(num) from chuku where class_name=ruku.class_name),0)
from ruku
where isnull((select sum(num) from chuku where class_name=ruku.class_name),0)>0
group by class_name

Answer 11

剪子夫人和nanran520看错了吧
是从chuku,ruku两个表中取的啊

Answer 12

没有kucun这个列我这是计算：出库，入库，库存和结余的中间很多SQL删节了，出问题的部份我列出来了

Answer 13

是看错了。
 insert into jieyu (class_name,num) 
select r.class_name,kucun=isnull(sum(c.num),0)
from ruku r
left join chuku c
on r.class_name=c.class_name
group by r.class_name
having(isnull(sum(num),0)>0)