[RESOLVED] MySQL query question

[anakadote]

Is there a way to force/enter a return value in a MySQL SELECT query?

For example, I want to query a table that has two columns: id and value. Can I write a SELECT query that appends a non-existent column to the result set? So, something like this:

SELECT `id`, `value`, `made_up_column` FROM `table`;

and have the value of "made_up_column" have a specific value for every row returned?

The reason being, I'm using a UNION to combine the results from two tables and want to know which table the result originated from.

[anakadote]

I got it, you would add a constant to the SELECT list:

SELECT `id`, `value`, 'something' AS `made_up_column` FROM `table`;