I agree with Sean. Please see the link he has referenced. We'll be able to give you better help with more complete information.

In the meantime, take a look at the WHERE clause in the query. It appears that you may have put WHERE conditions on the TBL_SRTTICKETMASTER table. If that's the case, it would prevent the LEFT JOIN from allowing the null conditions to be returned. Those would be the rows that you'll need to get your zero counts. Not sure if this is the issue but it's something you might want to investigate.

Here's an article[/url] that discusses the impact of WHERE clause filters on LEFT JOINS.