You have two tables named Customers and Orders. They are related by a foreign key constraint on the CustomerID on each table. You need to generate the following XML structure that includes all…

You have two tables named Customers and Orders. They are related by a foreign key constraint on the CustomerID on each table. You need to generate the following XML structure that includes all customers and their related orders. <Root> <Customer> <CustomerName>Customer1</CustomerName> <Orders> <Order> <OrderDate>1/1/2008</OrderDate> <OrderValue>422</OrderValue> </Order> <Order> <OrderDate>4/8/2008</OrderDate> <OrderValue>300</OrderValue> </Order> ... </Orders> ... </Customer> <Root> Which query should you use?