Adding to Query Results

  • Thread starter Thread starter Guest
  • Start date Start date
G

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