CREATE VIEW [Orders Summary] 
AS 
SELECT O.OrderId, O.CustomerId, C.CompanyName, O.OrderDate, O.ShippedDate, 
      ( FirstName + ' ' + LastName ) AS Salesperson, S.Subtotal AS SaleAmount 
   FROM Customers C 
      INNER JOIN ( Employees E 
         INNER JOIN ( Orders O 
            INNER JOIN [Order Subtotals] S 
         ON O.OrderId = S.OrderId ) 
      ON O.EmployeeId = E.EmployeeId ) 
   ON C.CustomerId = O.CustomerId