UNION ALL

SELECT 2 AS Tag,1 AS Parent,

Categories.CategoryID AS [Category!1!ID],

Categories.CategoryName AS [Category!1!Name],--这里可以使用NULL代替

ProductID  AS [Product!2!ProductID!element],

ProductName  AS [Product!2!ProductName!element]

FROM Categories

JOIN Products ON Categories.CategoryID = Products.CategoryID AND ProductID <5

WHERE Categories.CategoryID < 3

ORDER BY [Category!1!ID] DESC,[Product!2!ProductID!element] ASC

FOR XML EXPLICIT

返回结果：

<Category ID="2" Name="Condiments">

         <Product>

                   <ProductID>3</ProductID>

                   <ProductName>Aniseed Syrup</ProductName>

         </Product>

         <Product>

                   <ProductID>4</ProductID>

                   <ProductName>Chef Anton&apos;s Cajun Seasoning</ProductName>

         </Product>

</Category>

<Category ID="1" Name="Beverages">

         <Product>

                   <ProductID>1</ProductID>

                   <ProductName>Chai</ProductName>

 << 上一页  [11] [12] [13] [14] [15] [16] [17] [18] [19] [20]  ...  下一页 >>