SQL Server CLEAN & EASY
\nSELECT e.employee_id\nFROM Employees e\nLEFT JOIN Salaries s ON e.employee_id = s.employee_id\nWHERE e.name IS NULL OR s.salary IS NULL\nUNION\nSELECT s.emplo
```\nSELECT e.employee_id\nFROM Employees e\nLEFT JOIN Salaries s ON e.employee_id = s.employee_id\nWHERE e.name IS NULL OR s.salary IS NULL\nUNION\nSELECT s.employee_id\nFROM Employees e\nRIGHT JOIN Salaries s ON e.employee_id = s.employee_id\nWHERE e.employee_id IS NULL OR e.name IS NULL\nORDER BY employee_id ASC;\n```
[]