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
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');