Multiple row join

SELECT l.name AS subject_name,  
  t.last_name AS student_last_name,
  st.last_name AS teacher_last_name
FROM learning AS l 
JOIN subject s ON l.subject_id=s.id
JOIN student st ON l.student_id=st.id
JOIN teacher t ON l.teacher_id=t.id;

Source: learnsql.com

Similar codes

2 votes139 views1 answer
Oracle number to percentage
SQL
0 vote141 views1 answer
How to move a columns location in mysql
SQL
3 votes155 views3 answers
Raw select laravel
SQL
0 vote146 views1 answer
Oracle SQL join three tables and group by column
SQL
4 votes144 views1 answer
Datepart postgres
SQL
0 vote186 views1 answer
Prisma transaction
SQL
1 vote149 views1 answer
Altering the column name in MySQL to have a default value
SQL
18 votes142 views4 answers
Uninstall mysql ubuntu 18.04
SQL
4 votes164 views2 answers
Tables in sql
SQL
8 votes139 views3 answers
Postgresql connection string c#
SQL