怎么把count（compno）也加入到結(jié)果中 謝謝

reiyangbo

select a.cardno, c.nodetag,b.compname,a.cardholder,d.content,a.identifyno,b.telphno,b.compaddrs,b.taxno
from cardinfor a,cardcompinfor b,nodeinfor c,id_type d
where a.pri_card='1'
and a. cardstatus='04'
and a.compno=b.compno
and a.nodeno=c.nodeno
and a.identitytype=d.code
and a.compno in (select compno from cardinfor where cardstatus='04' group by compno having count(compno)>100)
如何在結(jié)果中加入count(compno)列  （count(compno)>100）

Eisen

select a.cardno, c.nodetag,b.compname,a.cardholder,d.content,a.identifyno,b.telphno,b.compaddrs,b.taxno,count(e.compno)
from cardinfor a,cardcompinfor b,nodeinfor c,id_type d,(select compno from cardinfor where cardstatus='04' group by compno having count(compno)>100) e
where a.pri_card='1'
and a. cardstatus='04'
and a.compno=b.compno
and a.nodeno=c.nodeno
and a.identitytype=d.code
and a.compno = e.compno
group by a.cardno, c.nodetag,b.compname,a.cardholder,d.content,a.identifyno,b.telphno,b.compaddrs,b.taxno
這樣行不行?