title: Codeigniter - join() returns only one "first table"
body: <p>I have struggle with codeigniter active record in my model.</p>
  
  <p>Problem is that my query returns only one table, my joined table is missing?</p>
  
  <pre><code>    $this-&gt;db-&gt;select("page.ID, page.TITLE, category.TITLE");
      $this-&gt;db-&gt;from('page');
      $this-&gt;db-&gt;join('category','page.ID_CATEGORY = category.ID');
      $query = $this-&gt;db-&gt;get();
  
      return $query-&gt;result_array();
  </code></pre>