title: Select query cannot join with another table - JOIN Zend Framework
body: <p>An error occurred
  Application error
  Exception information:</p>
  
  <p>Message: Select query cannot join with another table
  This is my code:</p>
  
  <pre><code>&lt;?php
  
  class Application_Model_DbTable_Seguimientos extends Zend_Db_Table_Abstract {
  
      protected $_name = 'Seguimientos';    
      public function buscarCaso($cod_beneficiario) {
          $consulta = $this-&gt;select()
  
          -&gt;from(array('seg' =&gt; 'Seguimientos'))
          -&gt;join(array('casos' =&gt; 'Asuntos_Estudiantiles'),
          'seg.cod_radicado = casos.codigo_radicado')
          -&gt;where('casos.cod_beneficiario = ?', $cod_beneficiario);
  
          $query = $this-&gt;fetchAll($consulta)-&gt;toArray();
          return $query;
      }
  }
  </code></pre>
  
  <p>I use <a href="http://framework.zend.com/manual/1.12/en/zend.db.select.html#zend.db.select.building.join" rel="noreferrer">Zend Framework 1</a>
  <img src="https://i.stack.imgur.com/9ENRZ.png" alt="error"></p>