[eluser]Unknown[/eluser]
Hi,
I need to reply this query with activerecord:
'SELECT tab1.name1, tab2.name2 FROM tab1,tab2 WHERE tab1.id=tab2.id'
I know how to use join instead of WHERE:
$this->db->select('name1');
$this->db->from('tab1');
$this->db->join('tab2', 'tab1.id=tab2.id');
... but I need the tab2.name2 value, and I can't add another table to 'from'.
Any help ??