TSQL Full outer join statement
\nSELECT ISNULL(A.employee_id,B.employee_id) AS employee_id\nFROM Employees A\nFULL OUTER JOIN Salaries B\nON A.employee_id = B.employee_id\nWHERE A.name IS NUL
```\nSELECT ISNULL(A.employee_id,B.employee_id) AS employee_id\nFROM Employees A\nFULL OUTER JOIN Salaries B\nON A.employee_id = B.employee_id\nWHERE A.name IS NULL OR B.salary IS NULL\nORDER BY employee_id\n```
[]