-- QUERY1 SELECT H.SalesOrderNumber, H.AccountNumber, S.Name AS [CustomerName], P.ProductID, P.Name, D.OrderQty, D.LineTotal FROM Sales.SalesOrderDetail D INNER JOIN Production.Product P ON P.ProductID = D.ProductID INNER JOIN Sales.SalesOrderHeader H ON H.SalesOrderID = D.SalesOrderID INNER JOIN Sales.Customer C ON C.CustomerID = H.CustomerID INNER JOIN Sales.Store S ON S.BusinessEntityID = C.StoreID WHERE D.SalesOrderID = 43933