sql 多表联接查询（超过有五张表，但是又分多种情况，子查询语句有十几条）统计然后分组

select (select orgname from org as og where org.id=og.id),
(select count(*) from tb1 as t1 whree t1.orgid=org.id) as number1,
(select count(*) from tb2 as t2 whree t2.orgid=org.id) as number2,
(select count(*) from tb3 as t3 whree t3.orgid=org.id) as number3,
(select count(*) from tb4 as t4 whree t4.orgid=org.id) as number4,
(select count(*) from tb5 as t5 whree t5.orgid=org.id) as number5 ,
。。。。。。。。。。。。。。。。。。。。。。。。number18
into #table from org as org,tb as tb where org.id=tborg.id
group by org.name having count(*)>0
go
select * from #table where number1<>0 and number2<>0 and number3<>0 and number4<>0 and number5 <>0
go

文字太多看到头晕，也不知道你要的结果是不是这个意思。希望能帮到你吧！

select * from(你的sql)
where number1+number2+number3+number4+number5 > 0