title: Getting unique column names to allow a creation of a view?
body: <p>I'm currently trying to create a view from two tables by doing a join, I've methods used here but i'm still getting this error: </p>
  
  <blockquote>
    <p>Msg 4506, Level 16, State >1, Procedure vw_Employee, Line 3 [Batch Start Line 19]<br>
    Column names in each view or function must be unique. Column name 'empNumber' in view or function 'vw_Employee' is specified more than once.</p>
  </blockquote>
  
  <p>My view is as follows:</p>
  
  <pre><code>create view vw_Employee as
  (
      select * 
      from Employees e1 
      inner join EmpInfo e2 on e2.empNumber = e1.empNumber
  )
  </code></pre>