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.