Aplogize for making two posts like this.
But I seem to be having another issue I am stuck on.
I want to make an append query, where I append values to a new column.


ID MyValue
1 0.2
2 0.3

APPEND CounterpartyValue
ID MyValue CounterpartyValue
1 0.2 0.3
2 0.3 0.4

How do I do this?

Many thanks
/ C