•Return results from both queries, including duplicate rows
Select employee_id, job_id, department_id
From employees
UNION ALL
Select employee_id, job_id, department_id
From job_history
Order by employee_id;
The combination of two tables totals to 30 rows. The UNION ALL operator does not eliminate duplicate rows.
0 comments:
Post a Comment