change the join to a LEFT JOIN
see the following page for details on the different join types:
http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/
to get the number of records use the count function. see this page for more info:
http://www.w3schools.com/sql/sql_func_count.asp
you may also need to use a GROUP BY clause:
http://www.w3schools.com/sql/sql_groupby.asp