Adding to Query Results

S

Sung

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
 
J

Jerry Whittle

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 ;
 
Top