title: MySQL Left Outer Join not returning NULL values for COUNT(*)
body: <p>I am attempting to left outer join 2 tables: TABLE1 contains a list of users and TABLE2 contains a list of forms completed by users. I want to display the count of forms by user, created after a given date, where status equals COMPLETED.</p>
  
  <p>The following query is working but not displaying NULL values (which I need):</p>
  
  <pre><code>select TABLE1.USERNAME, count(TABLE2.FORMS)
  from TABLE1
  left outer join TABLE2 on (TABLE2.USERID = TABLE1.USERID)
  and TABLE2.STATUS = COMPLETED
  where TABLE2.DATE &gt; 20140801
  group by TABLE1.USERNAME;
  </code></pre>
  
  <p>What do I need to do to include users with NULL counts i.e. no forms in TABLE2?</p>
  
  <p>Thanks</p>