title: MySql Count cannot show 0 values
body: <p>I have two tables one
  Employee and mailing Subscriptions
  Employee looks like this:</p>
  
  <p>Name (pk)  | Surname | Age</p>
  
  <p>mailing Subsriptions</p>
  
  <p>MailId (pk)| EmployeeName (fk)|Description | Date</p>
  
  <p>I wanted to subscription number for each customer, therefore I tried the following query:</p>
  
  <pre><code>Select COUNT(c.Name) 
  From Employee 
      INNER JOIN mailingSubscriptions as m ON c.Name = m.EmployeeName;
  </code></pre>
  
  <p>It will give me all counts for each Employee that <em>has</em> an entry in the mailing subscription.</p>
  
  <p>My problem is that I want to see the counts for ALL the Employees, including the ones without an entry (therefore to show 0), I tried an outer left/right join, but it will not work. Am I doing something wrong? </p>