title: INNER JOIN in MySQL
body: <p>There are my two tables:</p>
  
  <p>Table name: <strong>FRIENDS</strong></p>
  
  <pre><code>+-------+---------+---------+-------------------+
  |  id   |  firstName   |  lastName  | city      |
  +-------+--------------+------------+-----------+
  | 1     | dudi         | edri       | london    |
  | 2     | maor         | azulay     | madrid    |
  | 3     | batel        | azulay     | tel aviv  |
  | 4     | nir          | cohen      | barcelona |
  | 5     | evia         | perez      | miami     |
  | 6     | neria        | perez      | new-york  | 
  | 7     | nevo         | kakoun     | roma      |
  +-------+---------+---------+-------------------+
  </code></pre>
  
  <p>Table name: <strong>ORDERS</strong></p>
  
  <pre><code>+-------+---------+---------+-----------------+
  |  id   |  firstName   |  amount  | status    |
  +-------+--------------+----------+-----------+
  | 1     | dudi         | 5684     | shipped   |
  | 2     | maor         | 4896     | shipped   |
  | 3     | batel        | 2496     | delay     |
  +-------+--------------+----------+-----------+
  </code></pre>
  
  <p>my question is:
  I want the friends that have no order.
  The answer:</p>
  
  <pre><code>| 4     | nir          | cohen      | barcelona |
  | 5     | evia         | perez      | miami     |
  | 6     | neria        | perez      | new-york  | 
  | 7     | nevo         | kakoun     | roma      |
  +-------+---------+---------+-------------------+
  </code></pre>
  
  <p>how i wrote the query with inner join.
  Thanks.</p>