title: Join query codeigniter with where condition returns all rows
body: <p>Here is my join query for getting data from two tables.</p>
  
  <pre><code>$this-&gt;db-&gt;select('*');
  $this-&gt;db-&gt;from('george_hotel_bkd_customers');
  $this-&gt;db-&gt;where('george_hotel_bookings.bookingref',$ref);
  $this-&gt;db-&gt;join('george_hotel_bookings', 'george_hotel_bookings.user_id = george_hotel_bkd_customers.user_id');    
  $query = $this-&gt;db-&gt;get();
  </code></pre>
  
  <p>According to my <code>where</code> condition it returns only one  row but it will returns all the rows with matches the join condition.</p>
  
  <p>Seems like my where condition is not executed here.</p>
  
  <p>please help me</p>