title: Query two tables and replace values from one table in the second one
body: <p>Say I have two tables like so:</p>
  
  <pre><code>fruits
  -------------
  id | name   |
  -------------
  1  | Apple  |
  2  | Orange |
  3  | Pear   |
  -------------
  
  users
  -------------------
  id | name | fruit |
  -------------------
  1  | John | 3     |
  2  | Bob  | 2     |
  3  | Adam | 1     |
  -------------------
  </code></pre>
  
  <p>I would like to query both of those tables and in the result get user ID, his name and a fruit name (fruit ID in users table corresponds to the ID of the fruit) like so:</p>
  
  <pre><code>--------------------
  id | name | fruit  |
  --------------------
  1  | John | Pear   |
  2  | Bob  | Orange |
  3  | Adam | Apple  |
  -------------------
  </code></pre>
  
  <p>I tried joining those two with a query below with no success so far.</p>
  
  <pre><code>"SELECT * FROM users, fruits WHERE fruits.id = fruit"
  </code></pre>
  
  <p>Thanks in advance.</p>