Database: cre_Doc_Tracking_DB
Question: Show the ids of all employees who have either destroyed a document or made an authorization to do this.
SQL:
SELECT Destroyed_by_Employee_ID FROM Documents_to_be_destroyed UNION SELECT Destruction_Authorised_by_Employee_ID FROM Documents_to_be_destroyed