-- Remove sort in the select statement

Alter VIEW [VCustomer] 
AS
Select cus.CustomerId, refCode, CustomerName
From Customer as cus
Inner join CustomerDetails as dei on dei.CustomerId = cus.CustomerId