Yup, I was going to say that it was missing the GROUP BY clause as well.

Both solutions work, but I'm going with Luiz's as it's very simple, and since I...

Thanks! Will watch this space.

It can be more than 2.

This doesn't quite work. In the event when the table has the following entries,

StudentIDFavoriteSubject

1Subject1

1Subject2

2Subject1

2Subject2

When I run the query, I should only get all details of StudentID 1, but I get...

Thanks Mark-101232!

Works like a charm!