title: Return all wows, mached and unmatched in MySQL Query
body: <p>I have two tables and i'm like to query 2 tables to obtain a report.</p>
  
  <pre><code>POSITION
  +-------------+---------------+
  | position_id | position_name |
  +-------------+---------------+
  |     1       |     E1P1      |
  |     2       |     E1P2      |
  |     3       |     E3P3      |
  |     4       |     E4P4      |
  +-------------+---------------+   
  
  PEOPLE
  +------------+-------------+--------------------+
  | people_id  | people_name | people_position_id |
  +------------+-------------+--------------------+
  |     1      |    JOHN     |         2          |
  |     2      |    MARK     |         4          |
  +------------+-------------+--------------------+
  </code></pre>
  
  <p>QUERY</p>
  
  <pre><code>SELECT position_id, position_name, people_name FROM position
  RIGHT JOIN people ON people_position_id = position_id
  </code></pre>
  
  <p>When I use simple query I get only matched rows, ho to obtain all?</p>
  
  <p><strong>I'm like to obtain this result</strong></p>
  
  <pre><code>+----+----------+--------+
  | ID | POSITION | STATUS |
  +----+----------+--------+
  | 1  |   E1P1   | Empty  |
  | 2  |   E1P2   | JOHN   |
  | 3  |   E3P3   | Empty  |
  | 4  |   E4P4   | MARK   |
  +----+----------+--------+
  </code></pre>