[eluser]ChrisBraddock[/eluser]
This works Phil - thanks. Just what I was looking for. Just did something like:
Code:
$db2 = $this->load->database('db2', TRUE);
$this->db->select('t1.field1, t2.field2');
$this->db->from($this->db->database . 'table1 t1');
$this->db->join($db2->database . '.table2 t2', 't1.id = t2.id', 'left');
$query = $this->db->get();