SQL - INNER JOIN
Given the tables:
ID | Name
1 | John
2 | Emma
3 | Mike
StudentID | Score
1 | 85
2 | 90
4 | 75
What will be the result of this query?
StudentsID | Name
1 | John
2 | Emma
3 | Mike
ScoresStudentID | Score
1 | 85
2 | 90
4 | 75
What will be the result of this query?
SELECT Students.Name, Scores.Score FROM Students INNER JOIN Scores ON Students.ID = Scores.StudentID;