poniedziałek, 24 października 2011

Start

Test formatowania kodu SQL:
-- 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