Select query cannot join with another table - JOIN Zend Framework
mysql, php, zend-db, zend-framework
Solution
<?php
class Application_Model_DbTable_Seguimientos extends Zend_Db_Table_Abstract {
protected $_name = 'Seguimientos';
public function buscarCaso($cod_beneficiario) {
$consulta = $this->select()
->from(array('seg' => 'Seguimientos'))
->join(array('casos' => 'Asuntos_Estudiantiles'),
'seg.cod_radicado = casos.codigo_radicado')
->where('casos.cod_beneficiario = ?', $cod_beneficiario)
->setIntegrityCheck(false); // ADD This Line
$query = $this->fetchAll($consulta)->toArray();
return $query;
}
}
Solved by adding `->setIntegrityCheck(false)` ! =)
An explanation of why this helps is found at this question/answer
Problem
An error occurred Application error Exception information: Message: Select query cannot join with another table This is my code: ``` <?php class Application_Model_DbTable_Seguimientos extends Zend_Db_Table_Abstract { protected $_name = 'Seguimientos'; public function buscarCaso($cod_beneficiario) { $consulta = $this->select() ->from(array('seg' => 'Seguimientos')) ->join(array('casos' => 'Asuntos_Estudiantiles'), 'seg.cod_radicado = casos.codigo_radicado') ->where('casos.cod_beneficiario = ?', $cod_beneficiario); $query = $this->fetchAll($consulta)->toArray(); return $query; } } ``` I use Zend Framework 1