SQL Statements › SELECT › Example 2

Example 2

List the employee numbers of all employees:

• Whose department number begins with D or,
• Who are assigned to projects whose project number begins with AD.

  SELECT EMPNO
  FROM EMP
  WHERE WORKDEPT LIKE 'D%'
  UNION
  SELECT EMPNO
  FROM ASSIGNTBL
  WHERE PROJNO LIKE 'AD%'