Define column during selection and populate with fixed value
Posted on 2011-10-24
I'm sure this is pretty straight forward but I don't even know what key words to put in the search to be able to search for what I'm looking for.
Basically, I want to select some columns in a table. But I also want to add a column to this query and add a fixed value (the column is not in the table) i.e. the column I want to add is called 'Data Code' and the fixed value I want in that field is called 'UK'.
This just saves me from having to manually add the column and value in Excel once I've exported the data.
This not alias.