Joining with two table

Hi all

I have three table 1 is post,2 is post_like and third is post_fav

How i fetch all the records related to each other

post_like table contains the user_id,post_id and like_value(Like for 1 and dislike for 0)

How i fetch post_like value when fetching all the post

Read The Definitive Guide to Yii / Look at the code of the demo apps / use forum search and you should be able to solve your problem.

It’s one of the very basic things in Yii and a so often asked question here in the forum.