[eluser]Brad K Morse[/eluser]
Code:
$this->db->select("c.id");
$this->db->from("clients c");
$this->db->join("clients_programmes cp", "c.id = cp.client_id", "left");
$this->db->having("cp.p_close_reason", "none");
$query = $this->db->get();
Try that, $this->db->having() might do.
Or
Code:
$this->db->select("c.id");
$this->db->from("clients c");
$this->db->join("clients_programmes cp", "c.id = cp.client_id", "left");
$this->db->where("cp.p_close_reason", "none");
$query = $this->db->get();