title: Adding table prefix to join in Codeigniter
body: <p>I have Codeigniter setup to add the prefix kms_ to my active record queries. However, I am trying to do a join with two ON conditions and it doesn't prepend them.</p>
  
  <p>Right now I have to manually add them like so:</p>
  
  <pre><code>$this-&gt;db-&gt;join('site_items', 'kms_site_items.item_id = kms_items.id AND kms_site_items.site_id = 1', 'left');
  </code></pre>
  
  <p>Can I write this differently so that the table prefixes are added correctly?</p>
  
  <p>Is there a way to get something like this to work:</p>
  
  <pre><code>$this-&gt;db-&gt;join('site_items', 'site_items.item_id = items.id AND site_items.site_id = 1', 'left');
  </code></pre>