nestedqueryelements.sql

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

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