By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table students (student_id varchar2(10), student_name varchar2(100))
create table student_enrolments (student_id varchar2(20), course_id varchar2(20) )
create table teachers (course_id varchar2(20), last_name varchar2(20))
create table courses (course_id varchar2(20), course_name varchar2(20))
insert into students values (111, 'I am Me')
1 rows affected
insert into courses values (123, 'course name')
1 rows affected
insert into teachers values (123, 'teacher')
1 rows affected
insert into student_enrolments values (111, 123)
1 rows affected
select student_name, course_name, last_name
from students s
inner join student_enrolments se on s.student_id = se.student_id
inner join courses c on se.course_id = c.course_id
inner join teachers t on t.course_id = c.course_id
| STUDENT_NAME | COURSE_NAME | LAST_NAME |
|---|---|---|
| I am Me | course name | teacher |
select (select student_name from students s where s.student_id = se.student_id) as student_name,
(select course_name from courses c where c.course_id = se.course_id) as course_name,
(select last_name from teachers t where t.course_id = se.course_id) as last_name
from student_enrolments se
| STUDENT_NAME | COURSE_NAME | LAST_NAME |
|---|---|---|
| I am Me | course name | teacher |