[PHP] pobierz, plaintext 
<?php
class Model_Select extends Zend_Db_Table_Abstract
{
	protected $_name = 'articles';
	protected $_primary = 'i_id';
 
	public function join()
	{
		$select = $this->select()
						->from(array('a' => 'articles'),
                    array('i_id','i_name'))
            ->join(array('u' => 'users'),
                    'a.i_id = u.id',
                    array('username') );
 
		return $this->fetchAll($select);
	}
 
 
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
    public function joinAction()
    {
        // action body
        $modelselect = new Model_Select();
        //$modelselect->setIntegrityCheck(false);
		$this->view->select = $modelselect->join();
    }
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
echo $select;
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$select->setIntegrityCheck(false);
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$select = $this->select()
[PHP] pobierz, plaintext