Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
SELECT o.OrderID AS "Order/OrderID", o.OrderNumber AS "Order/OrderNumber", o.BillToFirstName AS "Order/BillToFirstName", o.BillToLastName AS "Order/BillToLastName", (Select p.Amount from ac_Payments p where p.OrderID = o.OrderID FOR XML PATH ('')) AS "Order/Payments/Amount" FROM ac_Orders AS o INNER JOIN ac_OrderItems as oi ON o.OrderID = oi.OrderID WHERE o.OrderID=104 FOR XML PATH ('O'), ROOT ('Orders'), ELEMENTS;
<Orders> <O> <Order> <OrderID>104</OrderID> <OrderNumber>104</OrderNumber> <BillToFirstName>Jean</BillToFirstName> <BillToLastName>Denny</BillToLastName> <Payments> <Amount><Amount>39.4400</Amount></Amount> </Payments> </Order> </O> <Orders>
Join the community of 500,000 technology professionals and ask your questions.