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.
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.