Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Saturday, July 15, 2017

How to get the students that have taken all classes in a list.

SQLServerCentral » Latest topics
How to get the students that have taken all classes in a list.
The basic structure of the significant tables is:  Student ---(1,M)-- Takes ---(M,1)---Course
How would I answer a question like this:
Show me all the students who have taken all classes in this list (Course1, Course2, Course3, Course4). I ca

No comments: