I have a table that contains a record of a student id and an interest they marked off on a survey.

StudentID, interest
3333333, 5
3333333, 45
3333333, 2
2222222, 45
2222222, 3
1111111, 3
1111111, 45
1111111, 59
1111111, 23


I want to make a query that will allow someone to enter a list of ids and return the ID's of students have selected those interests. EX. when someone enters 3 and 45, it will return 2222222, and 1111111.

Right now I can only get it by doing

select x.studentid
from 	(select studentid from studentsurvey where interest = 3) x, 
	(select studentid from studentsurvey where interest = 45) y
where x.studentid = y.studentid

Obvisouly this wount work too well if there is a dynamic number of interest to match. Any ideas.