how can i go about executing these querries using joins?

[sekitoleko]

Write a query to list:
all departments that don’t have employees,
all employees who don’t belong to any department.

[temat]

[all departments that don’t have employees]
[PHP]Select * From dbo.Departament s
Where depID NOT IN (SELECT depID FROM dbo.Employees)
GO[/PHP]

[ all employees who don’t belong to any department]
[PHP]Select * From dbo.Employees
Where depID NOT IN (SELECT depID FROM dbo.Departament s )
GO[/PHP]