simple solution(MSSQL)
1.\n\nselect employee_id from employees\nunion\nselect employee_id from salaries\nexcept\nselect employee_id from employees\nintersect \nselect employee_id from
1.\n```\nselect employee_id from employees\nunion\nselect employee_id from salaries\nexcept\nselect employee_id from employees\nintersect \nselect employee_id from salaries\n```\nunion of two tables minus intersection\n\nunion 1 2 4 5\nintersection 4 5 \nunion - intersection =1 2\n\n2.\n```\nselect employee_id from employees\nwhere employee_id not in (select employee_id from Salaries)\nunion\nselect employee_id from Salaries\nwhere employee_id not in (select employee_id from Employees)\n```\nplease upvote if you find it useful
['MS SQL Server']