title: INNER JOIN ON condition in codeigniter
body: <p>this is my mysql query</p>
  
  <pre><code>SELECT MAX(A.BID),B.* 
    FROM tbl_bid A 
   INNER 
    JOIN wl_customers B 
      ON A.customers_id=B.customers_id
   WHERE portfolio_id='$Id'
  </code></pre>
  
  <p>how to write this query in  codeigniter.</p>