How to add columns with fixed value

[wutaguy]

Hi!

I have a query and I would like to add 2 columns that have fixed value.

e.g. say if the query is

select A
into table 1
from table 2

The result is column A from table 2, but I would like the result to have 2 more columns with fixed value.

so the result should be table 1 with 3 columns

column A Column B Column C
A Value1 Value2


Thanks for any help.

 

[pbaldy]

select A, "Fixed Text" AS B, 123 AS C
...