hitestmail1
(hitestmail1@gmail.com)
1
Well suppose i have three table
User (PK : user_id)
Suggestion (PK : suggestion_id, FK : user_id )
UserRate (PK : user_rate, FK : user_id)
Now how can i join tables Suggestion and UserRate using Relation method
i am doing like
public function relations()
{
return array(
‘user’ => array(self::BELONGS_TO, ‘User’, ‘user_id’),
‘Rate’=>array(self::STATE,‘UserRate’,'user_id),
);
}
Here How to join Table Suggestion to UserRate with foreign key user_id 
selvakumar
(Selvakumar Kaliyappan)
2
Hi,
Using the following MySQL query you can execute the tables in database
[sql]SELECT * FROM Suggestion
INNER JOIN UserRate
ON Suggestion.user_id = UserRate.user_id;[/sql]
And i have no idea about how to execute the same in the YII. The same I’m also struggled. If you find any solution please help me…
hitestmail1
(hitestmail1@gmail.com)
3
ok, i will tell you when i will get the solution 