title: Join statement order of operation
body: <p>Given the following 3 way  join</p>
  
  <pre><code>select t1.* from t1
  left join t2 on t1.fk = t2.pk
  join t3 on t2.fk = t3.pk
  </code></pre>
  
  <p>If the join between t2 and t3 failed, would the row from the successful join between t1 and t2 be returned? If the order of operation goes from left to right, I assume not,  but if it's evaluated from right to left (t3 is joined to t2 first) then t1 will still be returned even when the former failed.</p>
  
  <p>How does it work?</p>