title: Oracle - how to perform left join on views?
body: <p>How to create a views using left join on Oracle?</p>
  <p>I am be able to create a join table using this statement</p>
  <pre class="lang-sql prettyprint-override"><code>select *
  from
      concert_copy c
      left join event_copy e
          on c.concert_id=e.concert_id;
  </code></pre>
  <p>But when I create views using this statement gave me error</p>
  <blockquote>
  <p>&quot;ORA-00957: duplicate column name&quot;</p>
  </blockquote>
  <pre class="lang-sql prettyprint-override"><code>create view concert_event as
      select *
      from
          concert_copy c
          left join event_copy e
              on c.concert_id=e.concert_id;
  </code></pre>