Hi, I have the following extract from a table called results.
StudentID Course Percent
1005 MAM1 63
1006 PHY2 55
1006 MAM1 71
I need to produce a list of student ID's WHO take MAM1 AND PHY2.
I first selected all rows where course is MAM1 OR PHY2, but then somehow I need to get rid of the student numbers that only take one of the courses! Please help!