Yep. And it shouldn't.
Look at this old post of mine in another forum:
You must move your WHERE clause into the ON or you will continue to get
results like that.
SELECT RT.ReportName, COUNT(CR.ReportTypeID) AS CNT
FROM ReportType RT LEFT OUTER JOIN ClientReport CR
ON ( RT.ReportTypeID = CR.ReportTypeID
AND CR.ReportGUID = '9D973D11-6ACC-4079-B4F8-DF4A733ED760' )
GROUP BY RT.ReportName
The parens aren't needed in SQL Server, but they don't hurt. (They are
needed in Access.)