Hello everyone, sorry for my bad language.



I've setup a small database for an exercise of my school.
It is a database to store a school information.
So, teachers, students, room and disciplines.

The exercise request a query: Produce a list of teachers of a single discipline.

I done this:
Code:
SELECT [teacher].[surname], [teacher].[name], [teacher].[discipline]
FROM teacher;
It work fine, but with this query I produce a list of all teachers with all disciplines.
The query request teachers of a single discipline, it must do a question to the user.

How can I do? Please help!

Not redirect me to search because I have problem with the language.