I have the following table structure:
user.id
user.firstname
user.lastname
user.email
course.id
course.name
students.id
students.userid
students.courseid
I need a list that gives me all of the students names and email for any given course. How can I achieve this?