title: CodeIgniter join select as
body: <p>I have 2 tables in my database which I need to join.
  1 table is the artikelen table and the other one is the collecties table. I currently have.</p>
  <pre><code>  $this-&gt;db-&gt;select('*');
    $this-&gt;db-&gt;from('collecties');
    $this-&gt;db-&gt;join('artikelen', 'artikelen.collecties_id = collecties.id');
  </code></pre>
  <p>It gives the right result but all the double fields (collecties has a title field and artikelen has a title field) will become one (it returns the artikelen.title field), and I can't access the row of the other table (the collecties.title field).</p>
  <p>I select 10 fields from artikelen and only collecties.title from collecties.</p>
  <p>What is the simples way to do this without having to replace</p>
  <pre><code>    $this-&gt;db-&gt;select('*');
  </code></pre>
  <p>with all the 10 fields with an as statement.</p>