多表连查SQL语句

[nosuchtracter]

我有三个表。Content C,Catalog A,Branch B
现在要统计每个部门B所发布的信息数，俩种状态
SQL语句如下：

select B.Name,B.status,
sum(case when C.status <> 99  and A.Report = 1  then 1 else 0 end) pub_cnt,
sum(case when C.status = 1 and A.Report = 1  then 1 else 0 end) confirmed_cnt
from
Branch B
left outer join Content c
on B.Id = C.BranchId
left join Catalog A
on C.CatalogId = a.Id and B.Status<>99
and (datediff(s,C.commitdate,@EndTime)>0)
	 and (datediff(s,@StartTime,C.Commitdate)>0) 
group by B.Name,B.status order by B.Name

但为什么B.Status<>99这句不起作用呢？会把表B种状态为99的也查询出来了
请问该如何写

[chuifengde]

and B.Status<>99===>>Where B.Status<>99

[wzy_love_sly]

...
where
B.Status<>99
and (datediff(s,C.commitdate,@EndTime)>0)
and (datediff(s,@StartTime,C.Commitdate)>0)
group by B.Name,B.status order by B.Name

[dobear_0922]

--try
select B.Name,B.status,
sum(case when C.status <> 99  and A.Report = 1  then 1 else 0 end) pub_cnt,
sum(case when C.status = 1 and A.Report = 1  then 1 else 0 end) confirmed_cnt
from
Branch B
left outer join Content c
on B.Id = C.BranchId
left join Catalog A
on C.CatalogId = a.Id 
where B.Status<>99
and (datediff(s,C.commitdate,@EndTime)>0)
     and (datediff(s,@StartTime,C.Commitdate)>0) 
group by B.Name,B.status order by B.Name

[nosuchtracter]

haha
老想别的地方晕了头了
结贴