帮忙看看这个sql语句！

[王者coco]

select count(*),st.studykind,fdz.fdzname from stusignsys as stu,fdzlist as fdz,studykindlist as st where stu.studykindID=st.studykindID and stu.fdzid=fdz.fdzid
and stu.stu_level='200703' and stu.signdate between '2003-01-10' and '2007-01-10' group by st.studykind,fdz.fdzname以上语句的意思是查询出某个服务站（fdz.fdzname）下的某个层次(st.studykind)的人数

现在想查询出满足signstate这个字段的人数，signstate有两个值，分别是1和0，要把该字段加到这个sql语句中，该怎么加呢？
就是在以上语句的基础上再分别查询出当signstate=1的时候人数和signstate=0时候的人数
我试着去查询了，但结果好像不太对。。。

[银狐被占用]

sum(case when signstate=1 then 1 else 0 end),sum(case when signstate=0 then 1 else 0 end)

[lzp4881]

select count(*),signstate0=sum(case when signstate=0 then 1 else 0 end),signstate1=sum(case when signstate=1 then 1 else 0 end),st.studykind,fdz.fdzname from stusignsys as stu,fdzlist as fdz,studykindlist as st where stu.studykindID=st.studykindID and stu.fdzid=fdz.fdzid
and stu.stu_level='200703' and stu.signdate between '2003-01-10' and '2007-01-10' group by st.studykind,fdz.fdzname

[王者coco]

没看懂，是sql语句还是asp代码？

[一把编程的菜刀]

什么数据库？

[王者coco]

sql2005
2楼写的没错，谢谢

[王者coco]

[Quote=引用 2 楼 lzp4881 的回复:]
select count(*),signstate0=sum(case when signstate=0 then 1 else 0 end),signstate1=sum(case when signstate=1 then 1 else 0 end),st.studykind,fdz.fdzname from stusignsys as stu,fdzlist as fdz,studykindlist as st where stu.studykindID=st.studykindID and stu.fdzid=fdz.fdzid
and stu.stu_level='200703' and stu.signdate between '2003-01-10' and '2007-01-10' group by st.studykind,fdz.fdzname
[/Quote]


这个程序要分别将signstate1和signstate0的人数显示在表格中呢，那这个语句还得分开写并且判断吧
就是在表格中显示signstate1和signstate0

[一把编程的菜刀]

不明白你什么意思
signstate1和signstate0已经分别代表了2个值，只要显示在你要显示你的表格中就可以了