T-SQL, zero sum for no match on join
I have two tables, one with all my Branches, and one with all my sales. The sales table also contains a Sales Rep ID, a Branch ID, a month and a year. 

I need a query that will return the sum of a specific rep's sales for a year, grouped by branch and month, and the query must return 0 if there has been no sales in a branch for that month. I have the following, which does not return 0 if there are no sales:

    SELECT
    	b.BranchName,
    	SUM(s.InvoiceAmount) AS 'Sales'
    FROM 
    	Branch b
    INNER JOIN
    	Sales s ON s.BranchID = b.BranchID
    WHERE
    	s.Year = 2008
    AND
    	s.SalesRepID= 11
    GROUP BY 
    	s.Month,
    	b.BranchName
    ORDER BY 
    	s.Month,
    	b.BranchName
T-SQL, zero sum for no match on join
===

I have two tables, one with all my Branches, and one with all my sales. The sales table also contains a Sales Rep ID, a Branch ID, a month and a year. 

I need a query that will return the sum of a specific rep's sales for a year, grouped by branch and month, and the query must return 0 if there has been no sales in a branch for that month. I have the following, which does not return 0 if there are no sales:

    SELECT
    	b.BranchName,
    	SUM(s.InvoiceAmount) AS 'Sales'
    FROM 
    	Branch b
    INNER JOIN
    	Sales s ON s.BranchID = b.BranchID
    WHERE
    	s.Year = 2008
    AND
    	s.SalesRepID= 11
    GROUP BY 
    	s.Month,
    	b.BranchName
    ORDER BY 
    	s.Month,
    	b.BranchName