YII 联合查询

首先两个model要建立relations。。

//Activity model
return array('card'=>array(self::HAS_ONE,'CommonCard','activity_id'));
//card model
return 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);