codeigniter left join right join code example Example: left join codeigniter $this->db->join('user_email', 'user_email.user_id = emails.id', 'left');