SQL SERVER CASE WHEN + FULL OUTER JOIN
\nSELECT CASE WHEN name IS NULL THEN s.employee_id\n            WHEN salary IS NULL THEN e.employee_id\n            END as employee_id\nFROM Employees e\nFULL O
```\nSELECT CASE WHEN name IS NULL THEN s.employee_id\n            WHEN salary IS NULL THEN e.employee_id\n            END as employee_id\nFROM Employees e\nFULL OUTER JOIN Salaries s\nON e.employee_id = s.employee_id\nWHERE name IS NULL or salary IS NULL          -- get the ones without proper information\nORDER BY employee_id\n```
[]