OK, I really have to get back to work now. But, here it is. This should get you most of the way.
<CFQUERY name="getOrders" datasource= username= password=>
SELECT OrderID.OrderDate, OrderID.OrderID, ProductID.ProductName, ProductID.ProductID, CartID.Quantity, ProductID.Price
FROM...