Hi,
I have a table of student courses. There are a few columns but the key ones are StudentName and EnrolledCourses. The data are as the names suggest.
Is it possible to run a query to find all students that have enrolled in both of two specific courses (Maths and English)? In other words the query should exclude any student that was not enrolled in only one of the two courses.
Thanks,
Rob