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

0 vote245 views1 answer
Xampp mysql version
SQL
0 vote278 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote266 views1 answer
Sql last 3 rows
SQL
0 vote246 views1 answer
How to get employee having maximum experience in mysql
SQL
4 votes251 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote256 views1 answer
Mssql check if date is greater than today
SQL
0 vote241 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote245 views2 answers
Limit sqlserver
SQL
2 votes248 views1 answer
Check isolation level in mysql
SQL
0 vote254 views1 answer
Pl sql constraint user function
SQL