title: left join turns into inner join
body: <pre><code>SELECT
  a.foo
  b.bar
  c.foobar
  FROM tableOne AS a
  INNER JOIN tableTwo AS b ON a.pk = b.fk
  LEFT JOIN tableThree AS c ON b.pk = c.fk
  WHERE a.foo = 'something'
  AND c.foobar = 'somethingelse'
  </code></pre>
  
  <p>Having the and clause after the where clause seems to turn the left join into an inner join. The behavior i am seeing is if there isnt 'somethingelse' in tableThree there will be 0 rows returned.</p>
  
  <p>If i move c.foobar = 'somethingelse' into the join clause the stored join will act like a left join. </p>
  
  <pre><code>    SELECT
      a.foo
      b.bar
      c.foobar
      FROM tableOne AS a
      INNER JOIN tableTwo AS b ON a.pk = b.fk
      LEFT JOIN tableThree AS c ON b.pk = c.fk
      AND c.foobar = 'somethingelse'
      WHERE a.foo = 'something'
  </code></pre>
  
  <p>Can someone point me at some documentation describing why this happens? THank you very much</p>