title: Left Join Issue
body: <p>Am trying to do a left join along with a condition. Say this is my table:</p>
  
  <pre><code>a     b     c
  -------------------------
  1     1     NULL
  3     3     something
  </code></pre>
  
  <p>and my query is </p>
  
  <pre><code>select * from x left join y on x.a = y.b
  </code></pre>
  
  <p>The problem is that I don't want c to be "something" so when i add</p>
  
  <pre><code>select * from x left join y on x.a = y.b where y.c &lt;&gt; 'something'
  </code></pre>
  
  <p>it displays 0 rows. it should actually display</p>
  
  <pre><code>a     b     c
  -------------------------
  1     1     NULL
  </code></pre>