外部联接在我的应用程序中无效

Question

Outer join in codeigniter not working

    $this->db->select('*');
    $this->db->from('users');
    $this->db->join('userdetails','users.user_id=userdetails.user_id','outer');
    $query = $this->db->get();
    if($query->result())
       return $query->result();
    else
        return false;

Please help

Answer 1

When you write an outer join in MySQL, the keyword LEFT or RIGHT is required, while OUTER is optional. So use:

$this->db->join('userdetails','users.user_id=userdetails.user_id','left');