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

1 vote142 views1 answer
Update and replace mysql
SQL
0 vote154 views1 answer
Sql select random procentage from rows
SQL
0 vote150 views2 answers
How to display enum value sql server
SQL
0 vote152 views2 answers
How to find max and min salary in sql
SQL
51 votes381 views6 answers
Installing mysql on ubuntu
SQL
0 vote138 views1 answer
Sql server udf performance
SQL
2 votes147 views5 answers
Tablespace ORACLE
SQL
3 votes143 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
3 votes140 views1 answer
Ms sql skip take
SQL
0 vote134 views1 answer
Strat with in sql
SQL