title: Codeigniter: Column 'id' in order clause is ambiguous
body: <p>I'm using CodeIgniter's Active Record Classes and I'm retrieving an error using the following code:</p>
  
  <pre><code>$this-&gt;db-&gt;select("*");
  $this-&gt;db-&gt;order_by("id");
  $this-&gt;db-&gt;limit($limit, $offset);
  $this-&gt;db-&gt;from("atoms");
  $this-&gt;db-&gt;join("atommeta", "atommeta.atom_id = atoms.atom_id");
  
  $query  = $this-&gt;db-&gt;get();
  </code></pre>
  
  <p>It produces this error:</p>
  
  <pre><code>Error Number: 1052
  
  Column 'id' in order clause is ambiguous
  
  SELECT * FROM (`atoms`) JOIN `atommeta` ON `atommeta`.`atom_id` = `atoms`.`atom_id` ORDER BY `id` LIMIT 10
  
  Filename: /Applications/MAMP/htdocs/atom/models/atom_model.php
  
  Line Number: 197
  </code></pre>
  
  <p>Line 197: <code>$query  = $this-&gt;db-&gt;get();</code></p>
  
  <p>Any ideas as to why? It seems to be something to do with the <code>order_by</code></p>