SQL Statements › SELECT › Description › Example 2
List the employee numbers of all employees:
SELECT EMPNO FROM EMP WHERE WORKDEPT LIKE 'D%'
UNION
SELECT EMPNO FROM ASSIGNTBL WHERE PROJNO LIKE 'AD%'