Yii Join With Two Subquery, How To Add Params?

Yii 1.1 General Discussion
1

Hi all,

My SQL query is not working when used in Yii. I have problem with getting Criteria params and table aliases to work. I want it in AciveRecord class

Here is my SQL query :


SELECT q1.*,q2.totair

FROM (

      SELECT invmo as invmo1,

      acct as acct,

      SUM(airchg) as airchg_1 

      FROM `ibank`  

      WHERE (invyr=2011) AND (client_id=10) 

      GROUP BY acct,invmo 

      ORDER BY invmo ASC

  ) q1   

LEFT JOIN (

           SELECT invmo as invmo2, sum(airchg) as totair

           FROM ibank 

           WHERE (invyr=2011) AND (client_id=10) 

           GROUP BY invmo 

) q2 

ON q1.invmo1=q2.invmo2 ;

Thanks in Advance…!!!

2

Getting help from this link -

http://www.yiiframework.com/doc/guide/1.1/en/database.query-builder