create proc sp_test
as
select
b.DepartName as 部门,
a.RealName as 姓名,
isnull(c.cnt1,0) as 日志总数,
isnull(d.cnt2,0) as 评价总数
from Member a
join Depart b on a.DepartID=b.ID
left join
(select MemID,count(1) as cnt1 from LogContent group by MemID) c
on a.ID=c.MemID
left join
(select MemID,count(1) as cnt2 from Comment group by MemID) d
on a.ID=d.MemID
