Cross Join

You are absolutely right.

I forgot the condition. Now it works right.

Code:

function immChild() {
   
   $this->db->select('c.id, c.name, b.id, b.fname, b.lname, a.id, a.child, a.immune, a.immun_date');
$this->db->join('immun_master as c', 'c.id = a.immune','true');
$this->db->join('children as b', 'a.child = b.id', 'true');
$query = $this->db->get('immun as a')->result();
       
return $query;
}