CODEWITHSUNDEEP
phpmysqlzend-frameworkzend-db
Jhosman
Jhosman

Reputation: 555

Select query cannot join with another table - JOIN Zend Framework

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 error

Upvotes: 7

Views: 12511

Answers (1)

Jhosman
Jhosman

Reputation: 555

<?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

Upvotes: 25

Related Questions