Multiple join on query builder

Hi guys,

I’m actually using Yii framework for now two days and having some trouble using the query builder.

Actually, it’s kind of easy to use it, but I’m trying to create one function taking all the parameters (select, from, join, where) and executing the query for me.

The fact is, I would like to use this function for severals queries. But each one has a different number of join.

Is there any way of doing all the join in one ?

Instead of doing




I would like to do only one


Thanks for your help