Codeigniter join query multiple conditions don't work

Question

I want to SELECT from my database table with a JOIN, but my attempt doesn't work.

My query:

$this->db->select();
$this->db->from('we');
$this->db->join('schedule', 'schedule.itemid = we.cid');
$this->db->join('schedule', 'schedule.itemtype = 'testitem'');
$this->db->where('we.isActive', 'Y');

This line makes problem with schedule.itemtype = 'testitem':

 $this->db->join('schedule', 'schedule.itemtype = 'testitem'');

How can I solve this?

Answer 1

You don't need to join same table twice. But just to extend ON clause:

$this->db->select();
$this->db->from('we');
$this->db->join('schedule', 'schedule.itemid = we.cid AND schedule.itemtype = \'testitem\'');
$this->db->where('we.isActive','Y');