drinks, coffees, teas, beers, and ales\>
代码： SELECT
Category.CategoryID,CategoryName,[Description],ProductID,ProductName FROM Categories Category INNER JOIN Products Product
ON Category.CategoryID=Product.CategoryID WHERE Category.CategoryID IN(1,2) ORDER BY Category.CategoryID FOR XML AUTO
4、使用FOR XML AUTO模式，从Categories和Products表中输出CategoryID为1或2的记录，包括每种类别的编号、名称、描述信息以及该种类别的产品信息，结果如下。
Category.CategoryID,CategoryName,[Description],ProductID,ProductName FROM Categories Category INNER JOIN Products Product
ON Category.CategoryID=Product.CategoryID WHERE Category.CategoryID IN(1,2) ORDER BY Category.CategoryID FOR XML AUTO,ELEMENTS 5、使用FOR XML PATH模式，检索每个订单及其客户的相关信息，部分结果如下，其中Address元素由Address，City及PostalCode构成。
59 rue de l'Abbaye Reims 51100
Luisenstr. 48 Münster 44087
代码：
SELECT [Order].OrderID 'Order/@OrderID', OrderDate 'Order/@OrderDate', RequiredDate'Order/@Order',
Customer.CustomerID 'Order/Customer/@CustomerID', CompanyName 'Order/Customer/CompanyName', ContactName 'Order/Customer/ContactName', [Address] 'Order/Customer/Address/data()', City 'Order/Customer/Address/data()',
PostalCode 'Order/Customer/Address/data()' FROM Orders [Order]
INNER JOIN Customers Customer
ON [Order].CustomerID=Customer.CustomerID ORDER BY [Order].OrderID FOR XML PATH('')
6、选做：使用FOR XML PATH模式，检索10248号订单的相关信息，结果如下：
59 rue de l'Abbaye Reims 51100
59 rue de l'Abbaye Reims 51100