Union

•Number of columns must be same
•Return result from both queries after eliminating duplications

Select employee_id, job_id from employees
UNION
Select employee_id, job_id
From job_history;





The UNION operator eliminates any duplicate records. If records record in both employees and job history table are identical, the records are displayed only once.



0 comments:

Post a Comment