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]
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]