Hi @ all !
I’m trying to do a relational query that works fine under PHPmyadmin.
In that query I’m joining “forum posts” to a main table called “forum topics”.
Each post has one user_id so I’m wondering if CActiveRecord can do a such query.
As I tested CActiverecord always joins using the main id :
I’ll obtain :
id […] FROM
t LEFT OUTER JOIN
postId ON (
So I tried some relations like this :
But I always obtain :
where I expect :
Any suggestions ?