select a.需求id, sum(b.需求回复id)as 回复数量 from 需求表 a left join 需求回复表 b on a.rid=b.rid
对照修改一下 :select [sf_RQ].ID,[sf_RQ].[需求名称],count(1) as '回复数' from [sf_RQ],[sf_rq_comm] where [sf_RQ].ID=[sf_rq_comm].RID group by ID,[需求名称]
selec a.rid,count(1) as '回复数' from [sf_RQ] a,[sf_rq_comm] b where a.RID group by a.rid
--如果只是查找rid。 select [sf_RQ].ID,count(1) as '回复数' from [sf_RQ],[sf_rq_comm] where [sf_RQ].ID=[sf_rq_comm].RID group by ID --如果要到需求表的所有信息 select *,回复数=(select count(*) from [sf_rq_comm] where [sf_rq_comm].rid=[sf_RQ].rid) from [sf_RQ]
from 需求表 a left join 需求回复表 b
on a.rid=b.rid
from [sf_RQ],[sf_rq_comm]
where [sf_RQ].ID=[sf_rq_comm].RID
group by ID,[需求名称]
a.rid,count(1) as '回复数'
from
[sf_RQ] a,[sf_rq_comm] b
where
a.RID
group by
a.rid
select [sf_RQ].ID,count(1) as '回复数'
from [sf_RQ],[sf_rq_comm]
where [sf_RQ].ID=[sf_rq_comm].RID
group by ID
--如果要到需求表的所有信息
select *,回复数=(select count(*) from [sf_rq_comm] where [sf_rq_comm].rid=[sf_RQ].rid) from [sf_RQ]