CDbCriteria join more than 2 tables

Yii 1.1 General Discussion
1

$c = new CDbCriteria;

$c->select="*,

              COUNT(tbl_reply.idtbl_reply),


              COUNT(tbl_thread.idtbl_thread)";

$c->join="LEFT JOIN tbl_reply ON idtbl_user = tbl_reply.user_id";

// [color="#FF0000"]and I want to additional join :[/color] "LEFT JOIN tbl_thread ON idtbl_user = tbl_thread.user_id"

$c->group="idtbl_user";

==============================================================

Help me please !!

Thank you very much.

2

I believe you can do:




$c->join="LEFT JOIN tbl_reply ON idtbl_user = tbl_reply.user_id";

$c->join.=" LEFT JOIN tbl_thread ON idtbl_user = tbl_thread.user_id";
3

Ahhh that’s work !!

Thank you very much