This should give you the price of the products on their sell date.
SELECT D.product_name,
D.sell_date,
(SELECT TOP 1 M.price
FROM Master_table M
WHERE M.product_name = D.Product_name AND M.receive_date >= D.sell_date
ORDER BY M.receive_date DESC)
FROM Detail_table D