SQL - Set Operations
You have two tables:
Employees(emp_id INT, emp_name VARCHAR, dept VARCHAR)
Managers(manager_id INT, manager_name VARCHAR)
You want to combine employee and manager names into one list using a set operation. Which query correctly applies set operation column matching rules?
A)SELECT emp_id, emp_name FROM Employees UNION SELECT manager_id, manager_name FROM Managers;
B)SELECT emp_name FROM Employees UNION SELECT manager_name FROM Managers;
C)SELECT emp_name, dept FROM Employees UNION SELECT manager_name, manager_id FROM Managers;
D)SELECT emp_id, emp_name, dept FROM Employees UNION SELECT manager_id, manager_name FROM Managers;
