// 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 below
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);
$this->view->collDbRow = $collTable->pickaname();