Skip
Arish's avatar

290. Practice - VIEW 2

Exercise: View with Join

Create view combining tables.

Solution

sql
1CREATE VIEW student_courses AS
2SELECT s.name, c.course_name
3FROM students s
4JOIN courses c ON s.course_id = c.id;