Записать оператор, который возвращает фамилии преподавателей и названия кафедр, на которых они работают

SELECT Teacher.*, Chair.Chair_NAME FROM Chair WHERE Teacher.Chair_ID = Chair.Chair_ID
SELECT Teacher.*, Chair.Chair_NAME FROM Teacher WHERE Teacher.Chair_ID = Chair.Chair_ID
SELECT Teacher.*, Chair.Chair_NAME FROM Teacher, Chair WHERE Chair_ID = Chair_ID
SELECT Teacher.*, Chair.Chair_NAME FROM Teacher, Chair WHERE Teacher.Chair_ID = Chair.Chair_ID $$SELECT Teacher.*, Chair.Chair_NAME FROM Teacher, Chair WHERE Teacher = Chair

Для просмотра статистики ответов нужно залогиниться.