Yes bob. Since I'm getting the count of a column tat is left joined by a table 1, there are records listed that are not in T2.

But I can't filter not null records in where clause either since it'll become a inner join.

Need to modify the query accordingly. Can u help me out on this?