title: Adding filter on the right side table on Left outer joins
body: <p>On outer joins(lets take a left outer join in this case) how does adding a filter on the right side table work?</p>
  
  <pre><code>SELECT s.id, i.name FROM Student s 
  LEFT OUTER JOIN Student_Instructor i
  ON s.student_id=i.student_id
  AND i.name='John'
  </code></pre>
  
  <p>I understand that if the filter was on the <code>Student</code> table it would be more like "Get all rows with name= John first and join the tables". </p>
  
  <p>But I am not sure if that is the case if the filter is on the right side table(<code>Student_Instructor</code>). How does the filter <code>i.name='John'</code> gets interpreted? </p>
  
  <p>Thank you</p>