Easy |FULL OUTER JOIN | MS SQL | without union
It will work on ms sql.\n\nSELECT (CASE \n            WHEN e.employee_id IS null \n            THEN s.employee_id \n            ELSE e.employee_id \n        END
It will work on ms sql.\n```\nSELECT (CASE \n            WHEN e.employee_id IS null \n            THEN s.employee_id \n            ELSE e.employee_id \n        END) AS employee_id \nFROM employees e \nFULL OUTER JOIN salaries s \n    ON s.employee_id=e.employee_id\nWHERE e.name IS null \n      OR s.salary IS null\nORDER BY employee_id;\n```
[]