I noticed that you had the * wildcard incorrectly placed and there was no space before the "as" and no comma after [Previous Amount] according to your post.
the bottom should work:
"SELECT [Previous Amount] as Previous_Amount, " & My_CPI_session & " as My_CPI FROM [pensions]"