join question

[Stephan Huber]

Hi,

--On Samstag, 28. Juni 2003 13:01 Uhr -0400 Charles Yeomans 
<yeomans at desuetude.com> wrote:

> Given two students, I want to find all teachers that have both students
> in a class.

Ah ok, I understand. My solution was: find all teachers which have student 
1 or student 2 in their class.

Sorry, I don't know a solution, in my program I do the query like above and 
build the join by myself. I'm also interested in a correct solution with 
SQL.

Stephan