Model Relation Building On Multiple Fields

Hello,

Here when I use:




/**

 * @property integer $id_1_of_b

 * @property integer $id_2_of_b

 * @property integer $id_3_of_b

 */

class A extends CActiveRecord {

  ...

  public function relations() {

	'b' => array(self::BELONGS_TO, 'B', '', array(

    	'id_1_of_b' => 'id',

    	'id_2_of_b' => 'id',

    	'id_3_of_b' => 'id',

	)),

  }

  ...

}



then this creates SQL like after calling for this relation is:




SELECT * FROM `A` `t`

LEFT OUTER JOIN `B` `b` ON (`t`.`id_1_of_b` = `b`.`id` AND `t`.`id_2_of_b` = `b`.`id` AND `t`.`id_3_of_b` = `b`.`id`)



But what to do above for relation if I want SQL Like:




SELECT * FROM `A` `t`

LEFT OUTER JOIN `B` `b` ON  (`t`.`id_1_of_b` = `b`.`id` OR `t`.`id_2_of_b` = `b`.`id` OR  `t`.`id_3_of_b` = `b`.`id`)



Where are all masters!

No one is helping me or not understanding my problem!