Pulling a list with no duplicates

[Jerry Crosby]

I have a table of student records with a field for Teacher. The teacher
data is pulled from another table which only has the list of available
teacher names. There is a one-to-many relationship between the teacher
table and the student table.

What I need to do is to come up with the list of only those teachers
included in the student records table. (e.g., I may have 50 teachers in the
teacher table, but only 30 of them showing up in the student table, but some
show up more than once.)

If that makes sense, could someone tell me how to do it?

Thanks in advance.

Jerry

 

[Guest]

SELECT DISTINCT student.teacher
FROM student;

This should do it.

HTH
Martin

 

[Jerry Crosby]

Thanks, Martin. So simple...

Jerry