Multiple-Table Queries
Q:
Get the list of products for each customer order.
SELECT orderId, name, quantity
FROM Products, OrderDetails
WHERE id=productID;