title: How to join multiple tables in a view
body: <p>how to create view of this query anyone help me please, i want create view of this but its show me error</p>
  
  <blockquote>
    <p>Msg 4506, Level 16, State 1, Procedure ordersview, Line 3 Column names
    in each view or function must be unique. Column name 'ID' in view or
    function 'ordersview' is specified more than once.</p>
  </blockquote>
  
  <pre><code>CREATE VIEW ordersview
  AS
  Select * from UserClaimData cd
   Inner join UserClaimDeductions ud on
  ud.CLAIMID = cd.ID 
  Inner join UserClaimApproval  ua on
  ua.CLAIMID = cd.ID  
  inner join ClaimDataBreakdown cb on
  cb.CLAIMID = cd.ID
  inner join  AppExpenseTypes ae on
  ae.ID = cb.EXPENSETYPE 
  inner join AppNOWTypes an on
  ae.ID =  an.EXPENSETYPEID
  inner join  AppAreas aa on
  aa.ID = cb.AREAID 
  inner join AppZones az on
  cb.ZONEID = az.ID
  inner join AppRegions ar on
  ar.ID = cb.REGIONID
  </code></pre>