•Number of columns must be same
•Return result from both queries after eliminating duplications
Select employee_id, job_id from employeesUNIONSelect employee_id, job_idFrom 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