I have a table table1
with the following data
+--------------+---------+
| Courses | Student |
+--------------+---------+
| Maths | A |
| Maths | B |
| Maths | C |
| Maths | D |
| Science | A |
| Science | D |
| History | C |
| Geaography | D |
| Physics | A |
| Physics | B |
| Physics | C |
| Physics | D |
+--------+-----+---------+
In Search Page I want to be able to search for the that course the some students have , For example i want to search for the course that A, B,and C students all have in this case it should be Match and Physics and in this case Science will be excluded from the query because not all these student (A,B,C) have,
Please help, if it can not be done throughout search page i want to make a customer view or query for this and it would take the Student from other table