title: Joining tables from two databases using codeigniter
body: <p>In order to write query in codeigniter you need to write something like <code>$this-&gt;db-&gt;query</code> or <code>$someDB-&gt;query</code>. But what if I want to join tables from two different databases?</p>
  
  <p>I know that I can do it through pure php, using <code>mysqli_connect</code> and writing something like: </p>
  
  <pre><code>SELECT * FROM db1.table1 JOIN db2.table2
  </code></pre>
  
  <p>But is there a way to do it using codeigniter?</p>