dbprefix on multiple join conditions

[eluser]Unknown[/eluser]
Hi:

My solution was adding dbprefix manually:

Code:

$this->db->join('table',
  't1.field1 = t2.field2 AND '.$this->db->dbprefix.'t1.field3 = '.$this->db->dbprefix.'t2.field4', 'left');

Edited: better yet: using _protect_identifiers

Code:

$this->db->join('table',
  't1.field1 = t2.field2 AND'.
  $this->db->_protect_identifiers('t1.field3').
  '='.
  $this->db->_protect_identifiers('t2.field4'), 'left');