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