Creating Custom Relational Model

Hi,

New to this forum and Yii but not new to PHP and OOP

I was wondering if there is the ability to create a custom model class based on the relation result of custom columns from 2 tables?

as an e.g in pusedo

TableA1 has id column1 column2 TableA2 as pid column1 column4 // assuming that this is a TableA1 one to many in TableA2 and column1 being the relational/ foreign key…

thus

class TableA12 extends CActiveRecords {

// @column1, @column2, @pid, @column4 are properties based on fetched results

Hi,isekream. I wanted to do this, but cant. Did you resolve it?