Codeigniter Joins Example

                $this->db->select('*');
$this->db->from('tbl_samples_post');
$this->db->join('tbl_twitter_user','tbl_twitter_user.user_id = tbl_samples_post.user_id','left');
$this->db->join('tbl_follow','tbl_follow.sender_id = tbl_samples_post.user_id','left');
$this->db->where('tbl_follow.receiver_id',$receiver_id);
$this->db->or_where('tbl_samples_post.user_id',$receiver_id);
$this->db->order_by('tbl_samples_post.user_id','DESC');
$query = $this->db->get();
return $query->result_array();