[Solved] How to join each order with its price? [closed]
You can use inner join to get price for each product in orders table: Select o.customer_id, p.product_id, o.quantity, p.price from PRICES p inner join ORDERS o on p.product_id=o.product_id solved How to join each order with its price? [closed]