tus AS [Order!1!OrderStatus], Orders.OrderDate AS [Order!1!OrderDate], Orders.SubTotal AS [Order!1!SubTotal], Orders.Tax AS [Order!1!Tax], Orders.ShippingHandling AS [Order!1!ShippingHandling], Orders.ShipToName AS [Order!1!ShipToName], Orders.ShipToAddressId AS [Order!1!ShipToAddressId], NULL AS [OrderDetail!2!OrderDetailId], NULL AS [OrderDetail!2!OrderId], NULL AS [OrderDetail!2!ItemId], NULL AS [OrderDetail!2!UnitPrice], NULL AS [OrderDetail!2!Quantity] from Orders UNION ALL /*订单详细信息是子 XML元素 */ select 2 页码:[1] [2] [3] [4] [5] [6] [7] 第3页、共7页 |