select b.proid,count(1) countPro
from proinfo a inner join proPlan  b on a.proid=b.proid
group by b.proid

------解决方案--------------------
晕，看你代码和你的描述出入很大哦

------解决方案--------------------
SQL code

select a.proid,count(b.proid) as countPro
from proinfo a inner join proPlan b on a.proid=b.proid

------解决方案--------------------
探讨


搞定了，下次自己先想想。。。。

SELECT WF_R_PC.R_PC_ID,ISNULL(WF_R_PB.R_PC_IDCOUNT,0) 
FROM WF_Research_ProjectCharter AS WF_R_PC 
LEFT JOIN (SELECT R_PC_ID,COUNT(R_PC_ID) AS R_PC_IDCOUNT FROM WF_Research_Proje……


------解决方案--------------------
探讨


搞定了，下次自己先想想。。。。

SELECT WF_R_PC.R_PC_ID,ISNULL(WF_R_PB.R_PC_IDCOUNT,0) 
FROM WF_Research_ProjectCharter AS WF_R_PC 
LEFT JOIN (SELECT R_PC_ID,COUNT(R_PC_ID) AS R_PC_IDCOUNT FROM WF_Research_Proje……


------解决方案--------------------
探讨


搞定了，下次自己先想想。。。。

SELECT WF_R_PC.R_PC_ID,ISNULL(WF_R_PB.R_PC_IDCOUNT,0) 
FROM WF_Research_ProjectCharter AS WF_R_PC 
LEFT JOIN (SELECT R_PC_ID,COUNT(R_PC_ID) AS R_PC_IDCOUNT FROM WF_Research_Proje……


------解决方案--------------------
探讨

搞定了，下次自己先想想。。。。

SELECT WF_R_PC.R_PC_ID,ISNULL(WF_R_PB.R_PC_IDCOUNT,0) 
FROM WF_Research_ProjectCharter AS WF_R_PC 
LEFT JOIN (SELECT R_PC_ID,COUNT(R_PC_ID) AS R_PC_IDCOUNT FROM WF_Research_Projec……