求sql的查询方法
我想在统计的时候不统计免写表中某人那周的数据，要怎么写呢？
[解决办法]
select ryb.[Name] 姓名,isnull(tjs.b,0) 己写周报数, (select count(*) from 周期表 as zqb)-isnull(tjs.b,0)+isnull(tjs.c,0) 未写周报数
from 人员表 as ryb left join
( select MemberID,count(*) as b,
(select count(*) from 免写表 as mxb where MemberID=zbb.MemberID ) as c
from 周报表 as zbb
where not exists(select 1 from 免写表 as mxb where MemberID=zbb.MemberID and StartTime=zbb.StartTime and EndTime=zbb.EndTime )
group by MemberID ) as tjs on ryb.MemberID=tjs.MemberID
order by ryb.MemberID
