title: Zend Framework Select Objects And UNION()
body: <p>I'm pretty sure this is not possible in Zend Framework (I have searched the Web, the documentation and issue tracker) but I just want to make sure so I'm asking here.</p>
  
  <pre><code>$select = $this-&gt;select();
  $select-&gt;union($select1, $select2);
  </code></pre>
  
  <p>That doesn't work of course. To explain what I need. I need to use UNION() to merge 2 tables in a SELECT query, I know I could just do:</p>
  
  <pre><code>$select = "$select1 UNION $select2";
  </code></pre>
  
  <p>The problem is that would return a string and I need to get a select object so I can use it with Zend_Paginator.</p>
  
  <p>I have already solved the issue by modifying my database architecture but I'm just curious if there is some workaround for this.</p>