SELECT c.customer_id, o.order_id, o.order_date, p.product_name 
 FROM customer c, curr_order o, product p 
 WHERE customer.customer_id = curr_order.customer_id 
 AND o.product_id = p.product_id 
 ORDER BY o.order_amount; 

Show comments for this question (1)
Add comments
Link to this question