Zend provides JOIN, joinLeft, joinRight keywords to join two or multiple tables. you can make an sql object by calling select function of current model by:
$select = $this->getDbTable()->select();
Use below line to use JOIN terms in your SQL:
By default its integrity value set to True and it do not allow to use join with multiple tables. We set to False and then we can use JOIN.
You may also like these related posts