// 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'; } // END require_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);