I am looking for a query that would look for all students who are taking two specific courses. I would like the query to only pull up those students who are taking both classes. However, I can not put in the course code field the criteria class1 and class2 because the student is listed twice, once taking class1 and then taking class2. If I put class1 or class2, then all students taking either appear. Solutions anyone?
Thanks