title: Replicate a MySQL LEFT OUTER JOIN with Zend_Db_Select
body: <p>I have tried over and over again to replicate my MySQL query using the Zend_Db_Select object and I can't replicate the results in Zend.</p>
  
  <p>The MySQL query:</p>
  
  <pre><code>SELECT s.id, s.project_id 
  FROM staging s 
  LEFT OUTER JOIN results r ON s.id = r.id 
  WHERE r.id IS NULL
  </code></pre>
  
  <p>What I have in Zend:</p>
  
  <pre><code>$query = $db-&gt;select()
             -&gt;from(array('s' =&gt; 'staging'), array('id', 'project_id'))
             -&gt;joinLeft(array('r' =&gt; 'results'), 's.id = r.id')
             -&gt;where('r.id IS NULL');
  </code></pre>
  
  <p>The output of the query is giving me one empty row of <code>results</code> in Zend, and the correct rows directly in MySQL.</p>