/*多表查询 方法1*/
$adapater = Zend_Db_Table::getDefaultAdapter();
$select = $adapater->select();//得到一个Zend_Table_Select
$select->from('course','*');
$select->join('menu','menu.mid=course.categoryid','name');
//打印查询语句测试
//echo $select;
$result=$adapater->fetchAll($select);
//$result = $db->fetchAll($select);
//打印查询结果测试
print_r($result);
/*多表查询 方法2*/
$adapater = Zend_Db_Table::getDefaultAdapter();
$select = $adapater->select()//得到一个Zend_Table_Select
->from(array('cs'=>'course'), array('organizer'=>'cs.organizer'))
->join(array('mu'=>'menu'), 'mu.mid=cs.categoryid',array('categoryname'=>'mu.name'))
//->where('mu.mid'.$mid.'AND cs.categoryid= '.$categoryid);
->where('mu.mid=cs.categoryid');
//echo $select;
$result=$adapater->fetchAll($select);
print_r($result);