How to differentiate the data when realizing UNION on 2 SELECTS?

advertisements

If I have the following two tables :

Employes

Bob
Gina
John

Customers

Sandra
Pete
Mom

I will do a UNION for having :

Everyone

Bob
Gina
John
Sandra
Pete
Mom

The question is : In my result, how can I creat a dumn column of differenciate the data from my tables ?

Everyone

Bob (Emp)
Gina (Emp)
John (Emp
Sandra (Cus)
Pete (Cus)
Mom (Cus)

I want to know from with table the entry is from withouth adding a new column in the database...

SELECT Employes.name
FROM Employes
UNION
SELECT Customers.name
FROM Customers;


Just introduce a constant addition to the column (rather than the table):

SELECT name || ' (Emp)' as name FROM Employees
UNION
SELECT name || ' (Cus)' as name FROM Customers;

and spell "Employees" correctly :-)