correctly SQL script
SELECT 1 AS TAG,
NULL AS PARENT,
Customers.CustomerID AS [Customers!1!CustomerID],
Customers.CompanyName AS [Customers!1!CompanyName],
NULL AS [Orders!2!OrderID],
NULL AS [Orders!2!OrderDate],
NULL AS [Orders!2!ShipCity],
NULL AS [OrderDetails!3!ProductID],
NULL AS [OrderDetails!3!Quantity],
NULL AS [Products!4!ProductName]
FROM Customers INNER JOIN Orders
ON Customers.CustomerID = ORders.CustomerID
INNER JOIN [Order Details] OD ON od.OrderID = Orders.OrderID
INNER JOIN Products ON Products.ProductID = OD.ProductID
WHERE Products.ProductID = 9
UNION ALL
SELECT
2 AS TAG,
1 AS PARENT,
customers.customerID AS [Customers!1!CustomerID],
NULL AS [Customers!1!CompanyName],
Orders.OrderID AS [Orders!2!OrderID],
Orders.OrderDate AS [Orders!2!OrderDate],
Orders.ShipCity AS [Orders!2!ShipCity],
NULL AS [OrderDetails!3!ProductID],
NULL AS [OrderDetails!3!Quantity],
NULL AS [Products!4!ProductName]
FROM Customers INNER JOIN Orders
ON customers.customerID = Orders.CustomerID
INNER JOIN [Order Details] OD ON od.OrderID = Orders.OrderID
INNER JOIN Products ON Products.ProductID = OD.ProductID
WHERE Products.ProductID = 9
UNION ALL
SELECT
3 AS TAG,
2 AS PARENT,
Customers.CustomerID AS [Customers!1!CustomerID],
NULL AS [Customers!1!CompanyName],
Orders.OrderID AS [Orders!2!OrderID],
NULL AS [Orders!2!OrderDate],
NULL AS [Orders!2!ShipCity],
OD.ProductID AS [OrderDetails!3!ProductID],
OD.Quantity AS [OrderDetails!3!Quantity],
NULL AS [Products!4!ProductName]
FROM Customers INNER JOIN Orders
ON customers.customerID = Orders.CustomerID
INNER JOIN [Order Details] OD ON OD.OrderID = Orders.OrderID
INNER JOIN Products ON Products.ProductID = OD.ProductID
WHERE Products.ProductID = 9
ORDER BY [Customers!1!CustomerID], [Orders!2!OrderID]
FOR XML EXPLICIT
[返回] 中文XML论坛 - 专业的XML技术讨论区 →
XML.ORG.CN讨论区 - XML技术 → 『 DTD/XML Schema 』 → 有问题请教，高手帮忙啊，Qr在么？[求助]
(订阅本版)
2006/1/11 21:33:00
新浪微博
有问题请教，高手帮忙啊，Qr在么？[求助]
