项目表 proinfo 字段如下,proid为guid类型,主键,proname为项目名称.
proid proname 项目计划表 proPlan 字段如下,ppid,proid为guid类型,ppid为主键,proid为外键.指向proinfo表中的proid.
ppid proid 求proid,countPro(proid在表proPlan字段proid中出现的次数)?
proid proname 项目计划表 proPlan 字段如下,ppid,proid为guid类型,ppid为主键,proid为外键.指向proinfo表中的proid.
ppid proid 求proid,countPro(proid在表proPlan字段proid中出现的次数)?
from proPlan
group by proid
from proinfo a inner join proPlan b on a.proid=b.proid
group by b.proid
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_ProjectBudget GROUP BY R_PC_ID) AS WF_R_PB
ON WF_R_PC.R_PC_ID=WF_R_PB.R_PC_ID
select a.proid,count(b.proid) as countPro
from proinfo a inner join proPlan b on a.proid=b.proid