I have created a Database called Business with the 2 tables as follows:

Question

dbo.Orders
ID
OrderID
ItemName
Quantity
Price
SalesID

dbo.Sales
SalesID
FIrstName
LastName
OrderID

I need to create a stored procedure to show all the data from both tables in xml format. How do I do this.