Categories
Development

MySQL query for a list of courses that a student haven’t already signed in for

I have two tables one is filled with courses and their teachers and the other one is filled with students that signed in for some of those courses.
is there a way to set-up a query that shows me all courses for a particular student which he/she hasn’t already signed in for

Example

the outcome of the example for student F should be containing English,Chines,German and Spanish.

Thanks in advance for the help!

Leave a Reply

Your email address will not be published. Required fields are marked *