values incorrect while merging columns

HI niekdp,

It looks like you are wanting to merge Queries (not Columns).

In the Query Editor choose the Merge Queries button then select your transaction table in the top and the exchange rate table in the bottom.  You can merge on more than one key so you do not have to make your own key in each of the other tables, just select the date field in both tables and then hold the control key and select the Country Code (you will see little numbers in the headers and just make sure they match).

Then just expand the Table column that is added and  select only the Rate column