Re: [fw-general] I have an eror: Select query cannot join with another table

[alayn]

try setting Integritiy Check to false:
setIntegrityCheck

public function getBooksAuthors()
        {
                $select = $this->select();

                //Add next line
                $select->setIntegrityCheck(false);

                ->from(array('b' => 'books'))
                        ->join(array('a' => 'authorsy'), 'b.id =
a.id_book');
                
                return $this->fetchAll($select);
        }

--
Alayn Gortazar

El jue, 17-09-2009 a las 02:45 -0700, aoohralex escribió:
> Select query cannot join with another table