Oracle Select With Join

Yii 1.1 General Discussion
1

I have a little probleme:





$criteria=new CDbCriteria;

$criteria->alias = 't';


$criteria->join = 'left join campaign_channels c_ch on t.campaign_id = c_ch.campaign_id';

$criteria->addCondition('c_ch.channels_id='.$this->CHANNELS_ID);


$this->dataProvider = new CActiveDataProvider($this, array(

	'criteria'=>$criteria,

	'sort'=>array(

		'defaultOrder'=>'CAMPAIGN_ID desc',

	),

	'pagination'=>array(

	    'pageSize'=>Yii::app()->params['filterpagesize'],

	)

));

The oracle drop me error:

Any idea?

SOLVED:

I quote all fild and make it upper:




$criteria->join = 'left join "CAMPAIGN_CHANNELS" "c_ch" on "t"."CAMPAIGN_ID" = "c_ch"."CAMPAIGN_ID"';

$criteria->addCondition('"c_ch"."CHANNELS_ID"='.$this->CHANNELS_ID);