title: MySQL create view joining two tables
body: <p>How can I create a view that merges different columns with a different table? I have three tables for example: users, items and gifts (in this example it's a system that a user can give a gift to another user)</p>
  
  <p><code>users</code> table has information about users, <code>items</code> table has information about items and <code>gifts</code> table shows which user sent what gift to which user.</p>
  
  <p>What I want is to create a view like following:</p>
  
  <pre><code>user_from | user_to | gift_name  | gift_price
  sally     | john    | Teddy Bear | 10
  </code></pre>