首先两个model要建立relations。。
//Activity modelreturn array('card'=>array(self::HAS_ONE,'CommonCard','activity_id'));//card modelreturn array('activity'=>array(self::BELONGS_TO,'CommonActivity','activity_id')); 查询
$actCriteria = new CDbCriteria();//$actCriteria->select = "t.*,card.card_type,card.denomination";//$actCriteria->together = true;//$actCriteria->join = "inner join ekp_common_card card ON (t.id = card.activity_id)";//sql merchant=:mrchant and status!=:status and card.card_type=1$actCriteria->order = "t.gmt_modified desc";$actCriteria->with = array("card");$actCriteria->condition .= "t.merchant=:merchant and t.status!=:status and t.end>=:end and card.card_type=:cardType";//查询CommonActivity::model()->with("card")->findAll($actCriteria);