nestedquerytype.sql

来自「wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重」· SQL 代码 · 共 13 行

USE Northwind
GO
SELECT TOP 10 OrderID, CustomerID, EmployeeID, OrderDate,
(SELECT ProductID, CONVERT(decimal(6,2), UnitPrice) AS UnitPrice,
Quantity,CONVERT (decimal(3,3), Discount) AS Discount
FROM [Order Details] AS OrderDetail
WHERE OrderDetail.OrderID = [Order].OrderID
FOR XML AUTO, ELEMENTS, TYPE)
FROM Orders AS [Order]
ORDER BY OrderID DESC
FOR XML AUTO, ELEMENTS, TYPE
GO