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