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 votes187 views1 answer
Remove root password mysql
SQL
0 vote182 views1 answer
How to count null values in sql
SQL
0 vote193 views1 answer
Default password for mysql_secure_installation in mac
SQL
9 votes182 views4 answers
How to alter table column name in mysql
SQL
0 vote192 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote298 views1 answer
Sql insert exemplo
SQL
0 vote177 views1 answer
Sql server express download
SQL
4 votes184 views3 answers
Employee name starting with in sql
SQL
0 vote186 views1 answer
Recover deleted data from mysql database
SQL
0 vote209 views1 answer
Oracle date summer time
SQL