title: Need help creating a view
body: <pre><code>CREATE VIEW custowner
  AS
     (SELECT        
          RTRIM(p.FirstName)+ ' ' + p.LastName AS [name], 
          LEFT(p.Phone, 12) AS phone, 
          p.CellPhone AS cellphone, 
          LEFT(p.EMail, 22) AS email
      FROM  
          CUSTOMER_OWNER co 
      INNER JOIN 
          PEOPLE p ON co.PeopleID = p.PeopleId
      ORDER BY 
          name ASC);
  </code></pre>
  
  <p>I get an error:</p>
  
  <blockquote>
    <p>The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.</p>
  </blockquote>
  
  <p>How can I fix this?</p>