Oracle

Set Operator Sample.

Figo Kim 2006. 9. 1. 22:18 
SELECT employee_id, department_id

FROM   employee_id

WHERE (employee_id, department_id)

      IN(SELECT employee_id, department_id

         FROM employees

         {UNION|UNION ALL|INTERSECT|MINUS}

         SELECT employee_id, department_id

         FROM job_history);