title: How to create view with multiple joins on same table
body: <p>In my database I have these two tables:</p>
  
  <p><strong>Person</strong></p>
  
  <pre><code>+----+---------+---------+
  | pk |  name   | sirname |
  +----+---------+---------+
  |  1 | john    | leno    |
  |  2 | william | wallice |
  |  3 | eva     | apple   |
  |  4 | walter  | white   |
  +----+---------+---------+
  </code></pre>
  
  <p><strong>Request</strong></p>
  
  <pre><code>+----+-------------+----------+---------------+---------+---------+
  | pk | requestdate | accepted | requestperson | parent1 | parent2 |
  +----+-------------+----------+---------------+---------+---------+
  |  1 | 1/1/2014    | Y        |             1 | 2       | 3       |
  |  2 | 1/2/2014    | N        |             4 | NULL    | NULL    |
  +----+-------------+----------+---------------+---------+---------+
  </code></pre>
  
  <p>To get the requests I do:</p>
  
  <pre><code>SELECT * 
  FROM request
  LEFT JOIN person p_subject ON requestperson = p_subject.pk
  LEFT JOIN person p_parent1 ON parent1 = p_parent1.pk
  LEFT JOIN person p_parent2 ON parent2 = p_parent2.pk
  </code></pre>
  
  <p>This works perfect but when I want to create a VIEW:</p>
  
  <pre><code>CREATE VIEW v_request AS
  SELECT * 
  FROM request
  LEFT JOIN person p_subject ON requestperson = p_subject.pk
  LEFT JOIN person p_parent1 ON parent1 = p_parent1.pk
  LEFT JOIN person p_parent2 ON parent2 = p_parent2.pk
  </code></pre>
  
  <p>I get this error: <code>ORA-00957: duplicate column name</code></p>
  
  <p>I do not want to rename all columns manually. How can I fix this?</p>