SQL SERVER : FULL JOIN  -  UNION approaching
YOUR UPVOTE MAKE MY DAY <3\n\n\n# FULL JOIN\n\n/* Write your T-SQL query statement below */\nselect (\n            case when e.name is null then s.employee_id\n
# YOUR UPVOTE MAKE MY DAY <3\n\n\n# FULL JOIN\n```\n/* Write your T-SQL query statement below */\nselect (\n            case when e.name is null then s.employee_id\n                when s.salary is null then e.employee_id \n                end\n        ) as employee_id \nfrom employees e\nfull join salaries s\non s.employee_id=e.employee_id\nwhere name is null or salary is null\norder by case when e.name is null then s.employee_id\n                when s.salary is null then e.employee_id \n                end\n```\n# UNION\n```\nselect employee_id from employees where employee_id NOT IN\n(select employee_id from salaries)\nUNION\nselect employee_id from salaries where employee_id NOT IN\n(select employee_id from Employees )\norder by employee_id\n```
['MS SQL Server']