Exercise: All Combinations
Get all student-course combinations.
Solution
sql
1SELECT s.name, c.course_name
2FROM students s
3CROSS JOIN courses c;
Get all student-course combinations.
1SELECT s.name, c.course_name
2FROM students s
3CROSS JOIN courses c;