// this is what I need to do: // $select = mysql_fetch_object(mysql_query('SELECT * FROM pro p, cat c WHERE c.catHL = 1 AND c.catId = p.catId'));// this is what I already have...// Products.php :class Default_Db_Products extends Zend_Db_Table { protected $_name = 'missProducts'; protected $_primary = 'proId'; } class Default_Db_Collections extends Zend_Db_Table { protected $_name = 'missCollections'; protected $_primary = 'collId'; //try this public function pickaname() { $select = $this->getDefaultAdapter()->select(); $select->from(array('c' => 'cat')) ->join(array('p' => 'pro'), 'c.catId = p.catId') ->where('c.catHL = ?', 1); return $this->getDefaultAdapter()->fetchAll($select); } }// END//edits belowrequire_once('default/models/Db/Products.php'); $collTable = new Default_Db_Collections;//$proTable = new Default_Db_Products;//$collSelect = $collTable->select()->where('collHighLight = 1')->order('collId DESC')->limit('2');//$this->view->collDbRow = $collTable->fetchAll($collSelect);$this->view->collDbRow = $collTable->pickaname();