Exercise: Students with Courses
Join students with courses table.
Solution
sql
1SELECT s.name, c.course_name
2FROM students s
3INNER JOIN courses c ON s.course_id = c.id;
Join students with courses table.
1SELECT s.name, c.course_name
2FROM students s
3INNER JOIN courses c ON s.course_id = c.id;