title: need to display fields that has same name but different value when join in codeigniter
body: <p>I need to join two tables but both the table has a field named 'username' both the table has different values i, i need to display both values in the field 'username' how it possible in codeigniter</p>
  
  <pre><code>public function tech_work_completed($id) {
      $this-&gt;db-&gt;select('c.username,u.id,tw.*,w.*');
      $this-&gt;db-&gt;from('tbl_tech_work tw');
      $this-&gt;db-&gt;join('tbl_customers c', 'tw.user_id = c.id', 'left');
      $this-&gt;db-&gt;join('tbl_users u', 'u.id = tw.technician_id', 'left');
      $this-&gt;db-&gt;join('tbl_works w', 'w.user_id = c.id', 'left');
      $this-&gt;db-&gt;where('w.wrk_status', 'completed');
      $query = $this-&gt;db-&gt;get();
      return $query-&gt;result();
  }
  </code></pre>
  
  <p>this is my model , both table <code>tbl_customer</code> and <code>tbl_users</code> contain a field name username so when display username it get from <code>tbl_user</code>. I need from <code>tbl_customers</code></p>