USE Northwind
GO

-- this query:
SELECT Customers.CustomerID, Orders.OrderID
	FROM Customers, Orders 
	WHERE Customers.CustomerID = Orders.CustomerID 
	ORDER BY Customers.CustomerID 
	FOR XML AUTO, ROOT('NorthwindCustomers')
