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

6 votes348 views2 answers
Where clause in sql
SQL
0 vote337 views1 answer
Conda install pymysql "windows"
SQL
0 vote337 views1 answer
Get records in sql according to month name and count
SQL
0 vote332 views1 answer
Opensuse start MySQL
SQL
0 vote339 views1 answer
Criteria builder select subset of column
SQL
0 vote406 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote357 views1 answer
Helptext in sql
SQL
1 vote375 views1 answer
How to use db.execute
SQL
1 vote364 views1 answer
Sql dcl
SQL
0 vote355 views1 answer
Sql where part of string match
SQL