Multiple databases $this->db->join

[eluser]rogierb[/eluser]
Using the db active record it is probably possible but not like your trying now. This will just generate 2 different queries, one for each database.

First try it with a 'normal' sql query like
<code>
Select t1.id, t2.* from db1.mytable t1
left join db2.another_table t2 on (t1.id = td.first_id)
</code>

If you got the working try to rewrite it using active record using only one class.
As long as you make sure your connected to both databases it should work.

I've done it in the past although i'm not sure if it worked with active record