title: Mysql full outer join 3 tables with group by and count
body: <p>My query is only showing a subset of records of people who have messages for me whereas I want to return a list of all users wether  they have messages for me or not along with the count (or true/false, 0,1)</p>
  
  <pre><code>SELECT attendee.id, attendee.firstName, attendee.lastName, count(attendee_chat.to) 
  from attendee_chat
  INNER JOIN attendee ON attendee.id = attendee_chat.to
  INNER JOIN chat ON attendee_chat.id = chat.attendee_chat_id
  WHERE attendee.id &lt;&gt; 1
  GROUP BY attendee_chat.to;
  </code></pre>
  
  <p>picture is worth a thousand words.</p>
  
  <p><img src="https://i.stack.imgur.com/jCirs.png" alt="enter image description here"></p>