title: Sql Update with join in codeigniter
body: <p>Stuck up with an issue in codeigniter. I have the following query:</p>
  
  <pre><code>UPDATE
      tbl_print_title 
  INNER JOIN tbl_jp_lookups ON tbl_print_title.title_id = tbl_jp_lookups.id
  SET
      tbl_print_title.is_delete = 1,
      tbl_jp_lookups.is_delete = 1
  WHERE
      tbl_print_title.id = 5
  </code></pre>
  
  <p>I want to write this in codeigniter's query builder structure. It is working fine in phpmyadmin. I tried the following but it does not work. Please provide suggestion.</p>
  
  <pre><code>$this-&gt;db-&gt;set('prt.is_delete', '!is_delete');
  $this-&gt;db-&gt;set('lk.is_delete', '!is_delete'); 
  $this-&gt;db-&gt;where('prt.id',$id);    
  $this-&gt;db-&gt;update(TBL_PRINT_TITLE." as prt");  
  $this-&gt;db-&gt;join(TBL_JP_LOOKUPS." as lk", 'prt.title_id=lk.id'); 
  if($this-&gt;db-&gt;affected_rows() &gt; 0) { 
  return 1;
  } else { 
  return 0; 
  }
  </code></pre>