Help me

[Alberto Sotomayor]

Please help me

I have two tables
table 1 the rooms with the present price,
in table 2 the rent History

I need the price of the room for one week, if it does not exist,
the price of the previous week


Table 1

room_no Integer
room_type Integer
room_price Decimal(10,2)


Table 2

room_no Integer
year Integer
Week Integer
Price Decimal(10,2)

How can do this ?

Sorry for my English