SELECT name FROM teacher WHERE EXISTS (SELECT 1 FROM student WHERE teacher.teacher_id = student.teacher_id)
SELECT DISTINCT teacher.name FROM teacher INNER JOIN student ON teacher.teacher_id = student.teacher_id
This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
SELECT teacher.name FROM ( SELECT distinct student.teacher_id FROM student ) as T0 inner join teacher on T0.teacher_id = teacher.teacher_id
General News Suggestion Question Bug Answer Joke Praise Rant Admin
Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.