This is a document Template
SQL_SELF_UNION1
SELF UNION

SELECT EMPNO, ENAME FROM emp WHERE ENAME = 'SMITH' UNION SELECT EMPNO, ENAME FROM emp WHERE ENAME = 'JONES'