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.