Error while joining tables with Zend_Db

Question

Why am I getting this:

An error occurred

Application error

Exception information:

Message: Select query cannot join with another table

while trying to join two tables?

I have this line code inside my model which extends Zend_Db_Table_Abstract

public function getProjects() {
    $select = $this->select()
            ->from(array('sub' => $this))
            ->join(array('main' => 'main_projects'), 'main.mai_id = sub.mai_id');
    return $this->fetchAll($select);
}

And I use this in my controller: $this->view->entries = $this->sub_projects->getProjects();

Why the hell I get this error? I just want to make a simple join

SELECT sub.*, main.mai_title FROM sub_projects AS sub INNER JOIN main_projects AS main ON sub.mai_id = projects.mai_id;
enter code here

Community · Accepted Answer · 2017-05-23 12:01:09Z

1

I think here is your solution and explanation : http://www.mail-archive.com/[email protected]/msg24553.html Another solution here : Translating a query to use Zend_Db_Select

edited May 23, 2017 at 12:01

CommunityBot

11 silver badge

answered Sep 20, 2010 at 18:32

greg0ire

23.3k17 gold badges76 silver badges104 bronze badges

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

3 Comments

Rodrigo Souza Over a year ago

then I get: ` SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ccgss.object' doesn't exist`

Rodrigo Souza Over a year ago

Actually I also had to change $thisfor the name of the table

hichris123 Over a year ago

While this answer may theoretically answer the question, it is better to include the essential parts of the answer here, and provide the link for reference.

Collectives™ on Stack Overflow

Error while joining tables with Zend_Db

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related