Get value from table by another rows value and the column name

So, my problem is as follows: Firstly, I have the following table for currency exchange rates (for all currencies):   and second, I have a table of reservations, each reservation has a curre...