title: SQL missing 0 values
body: <p>I have problem with one query:</p>
  
  <pre><code>SELECT first_name, last_name, count(scheduleevents.id) 
  FROM workers
  JOIN scheduleevents 
  ON scheduleevents.worker_id = workers.id
  </code></pre>
  
  <p>This query result is:
  Workers who have some events ( more than 0) in scheduleevents table but i want workers with 0 events too.
  LEFT JOIN don`t work and IFNULL option so how i can resolve this problem?</p>