Содержимое статьи:

SELECT Departments.Names as факультет

FROM Chair

JOIN Departments ON Chair.ID_Departments=Departments.ID

WHERE Chair.Names IS NULL

2. Использование LEFT JOIN с условием ON:

SELECT Departments.Names as факультет

FROM Departments

LEFT JOIN Chair ON Chair.ID_Departments=Departments.ID

WHERE Chair.Names IS NULL

3. Использование RIGHT JOIN с условием ON:

SELECT Departments.Names as факультет

FROM Chair

RIGHT JOIN Departments ON Chair.ID_Departments=Departments.ID

WHERE Chair.Names IS NULL

4. Использование FULL JOIN:

SELECT Departments.Names as факультет

FROM Chair

FULL JOIN Departments ON Chair.ID_Departments=Departments.ID

WHERE Chair.Names IS NULL