Select query cannot join with another table - JOIN Zend Framework

Question

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

$select->setIntegrityCheck(false); add this line (from the below answer) — almaruf
– almaruf, Commented Jul 28, 2015 at 16:00

Community · Accepted Answer · 2017-05-23 12:18:11Z

25

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

edited May 23, 2017 at 12:18

CommunityBot

11 silver badge

answered Jul 6, 2014 at 2:21

Jhosman

5554 gold badges8 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Select query cannot join with another table - JOIN Zend Framework

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related