Thanks Stewart.. It worked as good...

The problem is there are no null values in T2.Columnname2 as such. But since it is left joined with T1, there are some null records as a result of this....

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...