In MS Access, I want to insert a new column into the returned result of a select query. The new column has the same value for every row. For example, my select returns columns A, B and I want C to be the new column created by the select query:
A B C
----------
a1 b1 c
a2 b2 c
a3 b3 c