title: how to inner join between three tables?
body: <p>I have three tables.</p>
  
  <pre><code>uers(id,name,email,passowrd,contact,address,city)
  items(id ,name,price)
  users_item(id,user_id,item_id,status)
  </code></pre>
  
  <p>here <code>user_id</code> and <code>item_id</code> is foreign key.
  how can i get resultant table with only <code>users_name,items_name,items_price,status</code> column?</p>