Display Relation Data As Left Join

Yii 1.1 General Discussion
1

Hi,

I have MANY-MANY relation between two tables.

Table 1 (id,pname)

Table 2 (id,gname)

Table 3 (id,t1_id,t2_id) is Many Many relation table between T1 and T2.

Table 2 is having HAS_MANY relationship with T2.

All the tables contains models.

Now i want to create LEFT JOIN kind of relation between T2 and T3 with where clause from t1_id . The output should be

for t1_id = 1

gname,t1_id

Group1,1

Group2,1

Group3,1

Group4,<null>

Group5,<null>

for t1_id = 2

Group1,<null>

Group2,2

Group3,2

Group4,<null>

Group5,<null>

How to apply criteria data using T3 Model?

thanks in advance,

Surendra