Adding to Query Results

[Guest]

I was wondering if this was possible. I have a query which pulls names from
a table. However, I want "All" to be added to the result set even thought
"All" isn't in the original table the query pulls from. Can this be done?

Thanks

 

[Guest]

SELECT employees.employee_name
FROM employees
UNION ALL
SELECT distinct "All"
FROM employees ;

Another way is to create another table with the same structure but only one
record.

SELECT *
FROM employees
UNION ALL
SELECT *
FROM tblAll ;