How to create a new column in a select query

sql ms-access select insert
Martin08 picture Martin08 · Sep 22, 2010 · Viewed 155.8k times · Source

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

Answer

D'Arcy Rittich picture D'Arcy Rittich · Sep 22, 2010 
select A, B, 'c' as C
from MyTable

Related questions

A select query selecting a select statement

I don't even know if I am doing this query the right way. There is a Sandwiches table that has some 7 fields and 2 of them are comboboxes (Type and Bread). So I made a query that combines all of the …

Read More
SQL SELECT multiple INNER JOINs

its Access database.. i have a Library table, where Autnm Topic Size Cover Lang are foreign keys each record is actually a book which has its properties such as author and stuff. i am not quite sure i am even …

Read More
How to do INSERT into a table records extracted from another table

I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this is a data warehousing query and I'm doing it in MS Access. So basically I want …

Read More