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 vote288 views1 answer
Sql select contem uma palavra
SQL
10 votes225 views2 answers
Select nextval from sequence oracle
SQL
0 vote199 views1 answer
Renombrar tabla mysql
SQL
0 vote199 views1 answer
Sql server select top 2 of each group
SQL
8 votes207 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote205 views2 answers
Default constraint in ms sql
SQL
-1 vote212 views1 answer
Adding a new table psql
SQL
0 vote206 views2 answers
Csv into data postgres
SQL
11 votes227 views3 answers
Sql line numbers
SQL
0 vote207 views1 answer
Show table details postgresql
SQL