Update based on date

[Ramesh]

HI,

I have a PriceList table with ProductID, RevisionDate, Price. There s
another Order table with ProductID, OrderDate, Price. Is there a way I can
update the value in the Price field of the Order table from the Price field
in the Pricelist table based on the SaleDate?

In other words, i need the Order table to have the Price as on the latest
RevisionDate before the Sale date for each product.

Can someone help please?

Thanks
Ramesh