title: Mysql & Joins Getting the desired results
body: <p>Ok so I have a players table with the following fields that matter.</p>
  
  <pre><code>id| team_id| first_name| last_name
  </code></pre>
  
  <p>I also have a pivot called event_player table containing the following fields.</p>
  
  <pre><code>event_id| player_id| availability| availability_notes
  </code></pre>
  
  <p>Now I need to fetch all the users that play for team_id = 1 but then also show if they are available for that event from the event_player table in the same sql.</p>
  
  <p>if i run </p>
  
  <pre><code>select * from `players` where team_id=1 ; 
  </code></pre>
  
  <p>I will get back all 17 players that currently play for team_id 1</p>
  
  <p>but I now need to see if they are available or not so i tried </p>
  
  <pre><code>select * from `players`  
       JOIN event_player
  ON event_player.player_id=players.id where team_id=1 and event_id=1 ;
  </code></pre>
  
  <p>but this only show the players that exist in the event_player and at the minute only 10 players have replied for this event. </p>
  
  <p>How can I also show the players that have not yet replied without showing all the other events?</p>
  
  <p>Thanks</p>