sql子查询，去重复！！！

[mofeiovi]

select (select orgname from org as og where org.id=og.id),
(select count(*) from tb1 as t1 whree t1.id=org.id) as number1,
(select count(*) from tb2 as t2 whree t2.id=org.id) as number2,
(select count(*) from tb3 as t3 whree t3.id=org.id) as number3,
(select count(*) from tb4 as t4 whree t4.id=org.id) as number4,
(select count(*) from tb5 as t5 whree t5.id=org.id) as number5
from org as org,tb as tb where org.id=tb.id
group by org.name having count(*)>0

语句也就是这么个意思，现在是查出来了，可是有那么几行查询结果为0的也显示出来了，我不想显示全为0的这
一行记录
如下：
orgname ------number1-------number2-------number3-------number4------number5
aaaa-----------0--------------2--------------0-------------1------------0
bbbb-----------1--------------0--------------0-------------0------------0
cccc-----------0--------------0--------------0-------------0------------0
dddd-----------0--------------2--------------0-------------0------------0
eeee-----------0--------------1--------------0-------------1------------0

就是不取出number1,number2,number3,number4,number5全为0的这一行记录
求大师指明！！！！！

[mofeiovi]

别沉了呀。。。。。。都给看看哇

[mofeiovi]

帮忙顶一下啊,在线等啊！！！！！

[叶子]

--嵌套一下
where number1+number2+number3+number4+number5<>0

[mofeiovi]

楼上的ＭＭ不行啊，number2...都无效

[火才松]

筛选一下，就只可以了：

having number1+number2+number3+number4+number5<>0

[snbxp]

select * from
(
select (select orgname from org as og where org.id=og.id),
(select count(*) from tb1 as t1 whree t1.id=org.id) as number1,
(select count(*) from tb2 as t2 whree t2.id=org.id) as number2,
(select count(*) from tb3 as t3 whree t3.id=org.id) as number3,
(select count(*) from tb4 as t4 whree t4.id=org.id) as number4,
(select count(*) from tb5 as t5 whree t5.id=org.id) as number5   
from org as org,tb as tb where org.id=tb.id  
group by org.name having count(*)>0
)A
where number1+number2+number3+number4+number5=0

[叶子]

[Quote=引用 3 楼 maco_wang 的回复:]
SQL code
--嵌套一下
where number1+number2+number3+number4+number5<>0
[/Quote]
我说的是嵌套一下，不是直接使用

[mofeiovi]

[Quote=引用 7 楼 maco_wang 的回复:]
引用 3 楼 maco_wang 的回复:
SQL code
--嵌套一下
where number1+number2+number3+number4+number5<>0

我说的是嵌套一下，不是直接使用
[/Quote]

谢谢，你的一语，惊醒了我啊。。。。。惨跪哇。。。。。。明天就实践